I am working on a model and it requires me to copy and paste 10x7 tables into a worksheet to get my results and then copying and pasting these results into another excel sheet. How would I do this using a loop to speed things up?
I am working on a model and it requires me to copy and paste 10x7 tables into a worksheet to get my results and then copying and pasting these results into another excel sheet. How would I do this using a loop to speed things up?
Johni.
Assuming the "results" are not the tables themselves that you are copying and pasting, but some data calculated from them, put the formula that gave you the results straight into the other sheet?
Ochimus
Thanks for the response but the sheet where the calculations are done are very formula heavy and I need to ultimately do the process for thousands of tables. That's why I need to come up with a macro to do so
johniu,
As I understand you, the "intermediate"" sheet starts as a copy of the data you have at the beginning.
The sheet then "does something" with that data, and generates results, which go onto the "final" sheet.
I'm saying get a macro on the "final" sheet to start with the data you copy onto the "intermediate" sheet at the moment, and do whatever it is that creates the "results" you get at the moment in the middle sheet.
If that is not the process, can you attach a sample file with a few rows showing the data you start with, and the formulae that creates the results you copy across to the final sheet.
Based on that, we can write the Macro to do it.
Ochimus
Hi,
I am unable to attach the sheet. Could I email you it?
I want the excel sheet to copy and paste the data from "sheet1" to "sheet2" for each week, then "sheet2" will do the calculations and those values will be pasted into "sheet3" for each week. If you could help me with writing a macro for this that would be great
johni.
Have sent you a Private message with the contact details,
Look forward to hearing from you, and hope I can help.
Ochimus
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks