I have not been able to find a solution to this problem. I am running excel 2007. I have 2 sheets, one is a log sheet and the other is a summary sheet. When the log sheet is opened, a new log sheet is created and a summary sheet is created. The log sheet is renames to mm-dd-yyyy Log and the summary sheet is renames to mm-dd-yyyy Summary. I need to copy various fields from the log to the summary. I THINK I can transfer the dada ok, but the problem for now is getting the correct sheet names. Ex: I need to copy cell F@ from the log to the summery. Please help. Thank you.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy from one sheet to another where the sheet names are based on the date
Similar threads
- Solved
- Question
