macro help.xlsx
hey everyone im a finance intern and i really need help in creating a macro that can take the same columns A101:A130, B101:B130, C101:C130, and J101:J130 and K101:K130 from multiple worksheets(about 60+) within the same file, and copy the contents into a summary like sheet named "Master List", and listing them out in columns C, D, E, F, and G, with the sheet name to show which sheet it came from, and the value from a fixed cell in each sheet to be listed out column A and B respectively? i attached a sample file above "macro help.xlxs" of the data and what i would like the outcome to be on the "Master List" sheet. thanks!
Bookmarks