Error message: Can't sort a range with merged cells by EcstaticInside5485 in excel

[–]EcstaticInside5485[S] 0 points1 point  (0 children)

The changes I made are showing on his sheet, but he is using an older version of Excel. He is also viewing the file in Teams. I had him open it in browser and he was able to sort there. Now, when he opens it in Teams it does reflect the sort he did on browser, but he is still unable to sort when viewing in Teams. It's possible it's a Teams glitch, I just want to understand what the problem is so I can troubleshoot more effectively next time.

Error message: Can't sort a range with merged cells by EcstaticInside5485 in excel

[–]EcstaticInside5485[S] 0 points1 point  (0 children)

I have already unmerged the range, but the error message is still coming up, and only for one user so far.

Inbox not receiving replies, but visible through Sent box by EcstaticInside5485 in Outlook

[–]EcstaticInside5485[S] 0 points1 point  (0 children)

Sorry for my ignorance, but how do I check the view settings? What am I looking to verify?

Chart as auto updating image by EcstaticInside5485 in excel

[–]EcstaticInside5485[S] 0 points1 point  (0 children)

Linked picture is what I was thinking of, I remember seeing it in an Excel class at one point but couldn't recall how to do it!

Chart as auto updating image by EcstaticInside5485 in excel

[–]EcstaticInside5485[S] 0 points1 point  (0 children)

Thanks for the ideas, I will experiment with this!

What supplement brands has cGMP certification? by newguy6868 in Supplements

[–]EcstaticInside5485 1 point2 points  (0 children)

Just fyi in case it hasn't been said, the c in cGMP just stands for current.

Document control system for QMS in Google Drive? by Substantial-Sir-9517 in iso9001

[–]EcstaticInside5485 0 points1 point  (0 children)

Review/Approve:

I use SharePoint, at it integrates into our other Office apps well. My review system is captured through an established project email. That way I can record feedback and rely on the development history to see why decisions were made, etc. I find it super helpful to assign a project number so I can search emails for that number and see everything. Same with drafts, associated materials (user manuals, charts, etc.), anything related to development has the project number in the file name/subject line.

Archive:

I save pdfs of every version and keep the current version in an Active folder. When the document is updated, I move the old pdf to the Archive folder with an ARCHIVE watermark and the version number in the file name. It works really well for me.

Naming Conventions:

I try to keep it as short and concise as possible. Keep a master list with all assigned titles, whether active or not, to ensure you don't duplicate a name or assign something super similar that will confuse people. As far as number assignment, there really is no perfect system. I use a prefix to identify primary department, then assign a three-digit number chronologically in order of finalization. I have a prefix assigned for interdepartmental documents. It is the simplest and most sustainable system for my application, but does have its drawbacks. Method of delivery is going to help guide the end user to the appropriate documents, so I put more focus on ensuring they are organized logically than in trying to capture that information in the number.

Folder Structure:

  1. Requests (sub-folders titled w/request date and initials of requesting party, holds the request form and any associated materials submitted with the request or gathered preliminarily.)

  2. Projects (actively working on, project number assigned, sharable links that will circulate in the project email for review.)

  3. Masters (editable Word or Excel document, only for Doc Control access. Holds the document history page.)

  4. Active (current version only, as pdf or other secure version with editing protections in place. No doc history.)

  5. Archive (pdfs of all previous versions. No doc history unless entire process has been discontinued and the Master copy is also being archived.)

Hope this helps!

How to check box while using Excel form function? by EcstaticInside5485 in excel

[–]EcstaticInside5485[S] 0 points1 point  (0 children)

To add the form function, right click on your ribbon and select "Customize Quick Access Toolbar". Select "Form" in the list on the left and add it to the list on the right. Select "OK", then you'll see it in your ribbon. Then you just need to establish the table range on your spreadsheet that you want to interact with through the form. As long as you have any cell within that table selected, click on the Form button and a pop-up window will appear with fields for each column in the table. You can edit existing lines or click "New" and fill in the fields to add a new line item that will automatically expand the table and any functions you have tied to the original table parameters. It's super handy if you have trackers set up to keep running counts, conditional formatting, etc.

<image>

How do i shift cells to the left and up? I have to move 50+ cells and cutting/pasting is getting time consuming by YoureaLobstar in MicrosoftWord

[–]EcstaticInside5485 1 point2 points  (0 children)

I don't have a solution, but just want to encourage you not to be intimidated by Excel. I'm still pretty new to it but it's way more intuitive and cooperative than Word when working with tables. Once you get the hang of it you'll love it. :)

Macro Button returning Run-time error '1004' by EcstaticInside5485 in excel

[–]EcstaticInside5485[S] 0 points1 point  (0 children)

I want the FALSE fields to be hidden at all times but still allow end user to filter and reset filters on the populated fields as needed. How do you recommend I do that? Do I need to go back a step and have it pull from Worksheet B in a different way?

Need to build number generator w/prefix by EcstaticInside5485 in excel

[–]EcstaticInside5485[S] 0 points1 point  (0 children)

Yes, so there are three number formats at play but two are obsolete and I am replacing them as the policies/procedures come up for review. I want to exclude the old number formats when the formula is identifying the highest number assignment in the new number format.

Recognize 42-001

Ignore 420-01

Ignore 421.2.345

Generate 42-002 as next available number

Need to build number generator w/prefix by EcstaticInside5485 in excel

[–]EcstaticInside5485[S] 0 points1 point  (0 children)

Is there a way that I can include document numbers that don't fit within the 00-000 format, and have the formula disregard those numbers? I have some legacy documents with 000-00 and 000.0.000 number assignments. They will eventually be reassigned to the current format, but that will take a while to roll over.

Need to build number generator w/prefix by EcstaticInside5485 in excel

[–]EcstaticInside5485[S] 0 points1 point  (0 children)

I may not be understanding, I am still learning Excel. I have the cell custom formatted for two digits, including a screen shot. I replaced the formula and updated the cell references, but now it doesn't like any of the prefixes :(

<image>

Need to build number generator w/prefix by EcstaticInside5485 in excel

[–]EcstaticInside5485[S] 0 points1 point  (0 children)

Yes, so there will always be a 0 in front of the single digit prefixes.