I have a workbook with 20+ worksheets. Each worksheet has a specific column (F) that I have a total and then offset by 2 rows and then multiply the total by 65%. It is this value that I need to copy. It is never in the same place for each worksheet or week to week.
I have attempted to create a code to automate copying this new value and pasting it to a corresponding worksheet in another workbook. I am am terrible at loops and end up just copying the same code over and over and "calling" it from the previous code. For some reason what I have done this time is wreaking havoc and causing the code to run forever and eventually error. It works ok if I do n ot use the "call feature" and just run one code at a time, but something mut be wrong and I am sure there is a much easier way to accomplish this. Here is my code:
I have this code for 25 different names (worksheets). Is there any possible way to streamline this? Basically my code is saying find the last used cell in column F and move down two rows--this is because there is a space in between so it will not find the actual last cell. Then copy that value and paste just the values into the corresponding sheet in a different workbook. then go to the next sheet and do the same thing. It seems easy enough but this is the best I can figure out how to do. Any help/explanation would be so very appreciated.Please Login or Register to view this content.
Thanks,
Kathy
Bookmarks