MACRO Question
Currently I run an excel spreadsheet that covers a variety of finance
information. I have to update information on thi spreadsheet ever week. One
Spreadsheet is CBC1 that I am working on this week and the other is CBC2 that
I will run when I get to work on Tuesday. The information change only by
amounts but I need my comments that I made from the previous the share over
to next. The Numbers that are Unique to each person that are on the
spreadsheet is the IRN. How do I update the information from one week to the
other week b the IRN and transfer the comment from that IRN to the next
week's spreadsheet into a MACRO? Please Advise any help would be appreciated.
|