Data Pulling
I'm trying to figure out the best way to pull data together from multiple tabs within an excel file. The file is made so that it can track issues within reports that are discovered. I'll try to break it down the best I can to explain what I have and what I'm trying to do. Within the file there are 5 tabs that are considered locations and they are named: LX, LV, CR, HR, FL Each tab is set up the same way with the only real important information in these columns of a table Column A - PCR Date Column C - PCR Owner Column G, I, K, M - Modification Category (1-4) these fields are actually drop down options from the Category Master List Within the file there is a 6th tab that has at able in it that is called Category Master List. Column A - Options for the dropdown in the above tab Modification Category columns Column B - Breakdown into one of three main categories (Billing, Compliance, Quality) Now this is what I'm trying to do: Fiscal Year Data (September 2025-August 2026) - I need to see how many times each of the dropdown options within the Master List show up in column G, I, K, M for each of the 5 location tabs. Monthly Data - I need to see how many times each of the dropdown options within the Master List show up in column G, I, K, M for each of the 5 location tabs along with how many times there is an entry with a date within that month. I would like to try and figure out how to put everything into one data table/chart type thing so it's easier to see and compare. Currently, everything needed is across a few different pivot tables and I would really like the data to pull itself automatically instead of me having to go in and copy all the data from one spot into another just to get the pivot results. Below is what I'm having to look at currently.
Power Query - SKU Generator
Hi, I am using MacBook Excel Version 16.102.2 I am trying to build a Power Query - that build out a SKU (e.g Column H). Based on the products I've entered in Column E and the Size Range chosen in Column F. I've managed to build a power query - but when I refresh nothing happens / updates. Some screenshots attached of my workings.
Hide Sheet after missusing shortcut Alt+H+W
I was working on an inventory and frequently using the shortcut mentioned above. Unfortunately, during one of those times, I must have misused it, and my sheet became hidden. Since then, I’ve tried multiple methods to unhide it, but none have worked. I would really appreciate your assistance in resolving this issue.
Administrator permissions
I am trying to save an edited spreadsheet, but Excel will not let me do this as it has opened the file as Read Only, and it tells me I need administrator permission. I can save the file on the desktop, but not in the folder I want (And if I then copy the file into the correct place it reverts to Read Only). Firstly I did not open the file as Read only. Secondly, when I checked in settings I am described as administrator! I have just installed Excel on a brand new PC, running Windows 11.Trouble inserting rows
I am receiving an error message while right clicking and attempting to insert rows above and below. The error message reads, "This operation is not allowed. The operation is attempting to shift cels in a table on your worksheet." No other users are currently signed onto the worksheet. How can I resolve this?
Remove sub-folder urls if the parent folder url exists
I have an excel sheet with one column which contain urls from sharepoint, the urls looks as follow:- /sites/Marketing/Budget /sites/Marketing/Budget/2015 /sites/Marketing/Budget/206 /sites/maps /sites/Expesnes /sites/Expenses/2020 now i want to delete all the sub-folders if their parent folder exists? so for example the above rows should be as follow:- /sites/Marketing/Budget /sites/maps /sites/Expesnes is there any script i can run to do this cleanup? ThanksExcel macro VBA issues
Hey guys. - I wrote a macro, which contain other macros using Call orders. If I running the macros separately everything ok, from the main macro one of them didn't running it's like it skipped from the list. Reason unknown. -On running I can see 4 application window get visible, and those didn't connect any kind of application. Also a Clipboard error message get visible, but I get a Clipboard cleaning macro, which several times cleaning the Clipboard, so it can't be. It's like a hack, or something which I don't recognize. - One a sheets called Total, I can't use the built in group function and can't collapse the selected section so the project I working on lost functionality. I didn't make any change on that side, but previously it was useable. Thanks for help in advance. Cheers. Zsolt
