EXCEL FORMULA HELP
I need help. I have attached the sheet I'm working on. I need to pull the data in column B (CLIENT) from the MAIN sheet to the respective individual sheet based on column E (PREPPER). For example, if the data in B4 says 'Jason Smith' and E4 says 'Jon'; I need it to go to the JON sheet in cell B4 but not show up on sheets JANE or MARLA. Help please!! Thank you! :)Excel’s "Very Hidden" Sheets… even the Unhide menu can’t find them
Just learned that Excel has a "Very Hidden" sheet state. Unlike normal hidden sheets, these don't show up in the “Unhide” menu at all. To create one: Press Alt + F11 to open VBA. In the Project Explorer, right-click a sheet → Properties. Change Visible from -1 (Visible) or 0 (Hidden) to 2 (Very Hidden). Now, only VBA (or the Developer tab) can bring it back. Perfect to keep things tidy or prevent accidental edits. Did anyone else know about this ninja-level Excel feature?
Setting Default Worksheet using Office Scripts
I'm working on an office script for Excel that generates the file as I want it, but for some reason, the file automatically opens up to the last sheet in the lineup instead of the first. I've tried a few methods like .activate() but they don't seem to work; only opening the file manually, switching to the first sheet, and saving does. Switching sheets also doesn't show up in when recording actions. Is there a command or method to make sure the file automatically opens up to the first sheet after my script is done setting up the document?BUG REPORT: Microsoft Excel Table Versioning Incompatibility Breaks Macro Logic
Excel tables now silently behave differently based on internal "versioning" (version 1 vs version 2), which is undocumented, invisible to the user, and directly breaks macros that previously worked across all sheets. There is no native method to identify which version a table is using, and users receive zero warnings when behavioral changes cause critical automation failures. Impact: .ListRows.Count and .ListRows(lastRow).Range.Delete fail inconsistently depending on the hidden version type Developers are forced to rewrite macros—not for logic reasons, but to compensate for Excel silently violating expected object behavior No version flag exposed in the UI, VBA, Power Query, or formula metadata Breaks trusted workflows for trainers, dashboard builders, and automation developers—especially during live sessions or instructional demos Forces users into non-consensual, destructive workarounds like converting the table to a range and rebuilding it from scratch. This should never be necessary. A user should not have to destroy a structured object to restore its usability. Repro Steps: Create a table via "Insert > Table" (defaults to version 2 silently) Copy data from older workbook sheets (some revert to version 1) Run macro using .ListRows(lastRow).Range.Delete Logic fails, errors, or behaves inconsistently Only workaround: convert table to range and rebuild—which is professionally unacceptable Temporary Workaround: On Error Resume Next With ActiveSheet.ListObjects(1) Dim lastRow As Range Set lastRow = .ListRows(.ListRows.Count).Range If Trim(lastRow.Cells(1, 1).Text) = "" Then lastRow.Delete End With On Error GoTo 0 Call to Action: Microsoft must publicly acknowledge the undocumented and silent divergence in structured table behavior between internal “version 1” and “version 2” implementations. This regression has: Broken established VBA logic Caused hours of untraceable macro failures Forced users into destructive workarounds Undermined trust during live instruction, client deliverables, and advanced workflow design Provided no way for users to identify table version—this is unacceptable We demand: Full disclosure of structured table version differences—what changed, why, and when Visible version metadata in Excel’s UI, VBA object model, and Power Query Behavioral standardization across workbook sources and creation methods Permanent removal of forced workarounds like converting tables to ranges just to restore row deletion logic Public bug tracking, resolution timeline, and community updates If Microsoft cannot provide these answers, then Excel structured tables must be considered unstable containers for automation. Developers and trainers cannot build trusted systems on invisible rules and undocumented regressions.A Little Help from my Friends
I am an advanced (expert) in Excel. I've used it for over 20 years everyday and have thousands of education hours under my belt. I would like to get some ideas on how some of you would approach this complex situation I have. I have already created three different methods but each have too many draw backs or failure points. With that said, I'll try to be brief but detailed enough for your thoughts. I have a file for which I'll call the Master-File it has a list of parts, suppliers, prices by month with Forecast and Actual. Current and Future months are forecast, previous months are actuals. I have 6 people that send me, what I'll refer to as Sub-Files. These subfiles contain the same headers as the Master-File. In the Master-File previous months data cannot change. (Ex. If reporting was done today 7/14 Actuals for June would be imported as Actuals and the remaining July thru December would be Forecast updated with the latest forecast data, which is already included in the sub-files). Months are listed left to right in columns not rows. Also, those sub-files can contain new parts that are required to be imported into the Master-File. My first solution was to use Power Query and import the Sub-files each month from a folder into the Master-file. Problem with that was, data from previous months would change in some of the Sub-Files and would over-write the data. (This data can't change once locked in). My second solution was to utilize a Unique ID for each record where I could easily identify new parts first and import that data by manually copying and pasting the data. Then sort the data using a match formula so the records in the Sub-file matched the Master-file and then manually copy and paste in the Actual and Forecast data. Some data was not correctly matched, so I started using XLOOKUP to import the data in the Actual and Forecast. Then, copy and paste as values. With 6 different files the table would at times over-write the data in the Actual forecast fields causing errors. Even after turning off auto table formula update option. Plus, this was very time consuming. Now I am starting over. I have some other ideas but if two heads are better than one then many heads are even better. I would love to hear your thoughts on how you would go about handling this process.
Excel cell fill doesn't work.... !
Hi, I have all settings correct and still, randomly from time to time, for day or more, I cannot fill cells with data. It just taking first number from first cell and copy it ignoring numbers below, and only what I can see are formatting options (this where you change in ex. colour depends on data in the cell. Nothing seems to work, I have no updates pending, reset Excel or computer doesn't work. I use Excel daily and if this happen I have 1 or more days out of work possibility. What shall be fixed here? Help, please.
