I found part of this macro online and copied it letter for letter. The video unfortunately cuts off the code so I can’t see the bottom of the document. I tried to accomplish making a macro for the graph formatting originally by recording clicks but it didn’t work. When I run this code it says “Compile error: Unexpected End with”.

My organization publishes a weekly report in Excel format containing over 60 worksheets, each titled with an activity abbreviation. I am interested in specific worksheets only. Currently, I manually search and copy these worksheets into a new workbook. Existing VBA solutions appear to require predefined worksheet names in an array, which will not work in my case because when there is no activity, a corresponding worksheet titled with the activity code is not included in the workbook.

enter image description herei describe in the image, please support me and solve my problem

i am using the below codes to help open my workbook find a particular sheet within the workbook and copy and paste it inside another, but somehow the code ends with opening the workbook and they cant seem to find the exact sheet.

I want to loop through an excel and column rows.

I have a macro in excel that copies data from 5 tabs into one tab that is the master data file, and then into another where it hides some columns. Each time the macro is being ran, it deletes all the data from the two destination tabs. Everything works fine, but I would like to have an option to manually enter a comment in the destination tab and have it copied to the source tab. Is it even possible without altering the macro dramatically? The columns that are being hidden might be changed in the future and I would like to avoid having to change the macro every time they are.

I want to develop a code to take an affirmative statment (eg: Sam cleans the room.) and give a negative statement as an output (eg: Sam did not clean the room.)

I found a script and modified it to search for a filename in a folder and select the filename.
This code works fine when I use Shell "explorer.exe /select,""" & FilePath & """", vbNormalFocus to open the folder and select the filename. However, it keeps opening a new folder instance instead of using the currently opened folder.
I tried to use this code:

What I thought would be the easiest part of this project is the hardest.

I have written the macro below to export data to separate files (a single table / single worksheet to one workbook) that works fine. I am attempting to add code to the worksheet to highlight updates made by users to the values in the exported worksheet. I can add the code to the workbook, as illustrated, where it does not work, but cannot tweak the macro to add the code to the worksheet, where it does work.
Please point out my coding error!