getitdaily
MIS
Here's my scenario (and I hope this makes sense)...
I have two workbooks I'll call them book1 and book2.
Book1 has a layout sheet and a macro that copies the layout sheet into sheet1 and imports data from a delimited file. The user then renames the sheet with the previous month.
Book1 is the budget. Book2 has a layout sheet that gets copied into a new sheet and a macro that imports data from a delimited file. Again the user renames the sheet with the current month. Book2 is the actual. Book2 will be compared to book1.
My problem comes in that book2 has cell references to book1 but the data is dynamic.
book2 sheet 'january' references book1 sheet 'january' data for comparison. Every month the user will run the macro for both books. How do I get the sheet in book2 to reference dynamic sheet cells in book1?
I have two workbooks I'll call them book1 and book2.
Book1 has a layout sheet and a macro that copies the layout sheet into sheet1 and imports data from a delimited file. The user then renames the sheet with the previous month.
Book1 is the budget. Book2 has a layout sheet that gets copied into a new sheet and a macro that imports data from a delimited file. Again the user renames the sheet with the current month. Book2 is the actual. Book2 will be compared to book1.
My problem comes in that book2 has cell references to book1 but the data is dynamic.
book2 sheet 'january' references book1 sheet 'january' data for comparison. Every month the user will run the macro for both books. How do I get the sheet in book2 to reference dynamic sheet cells in book1?