Forum Discussion
How to copy/paste range from 1 workbook to another, based on sheet names
Hello excel community, I have a question that I am trying to solve that relates to using Macros and VBAs. I think it will help if I first detail what I am working with and then describe what I a...
Where I wrote "For each sheet in wb1", I am basically looking for code to add to sub "prepare_tables_1" at the very end, and then somehow use that generated array in the main sub.
The generated array will look something like this: ("Sheet 1", "A12"; "Sheet 2", "A14", "Sheet 3", "A16" ...). As you can see, for example, "Sheet 1" is paired with "A12"