walruseggman- this is what i am looking for..... if i might be able to burden you just a little more....... I have attached the new workbook that contains your macro.
Lets say that on Sheet1 J1 has a date in it. It will be the same date that will be used for all 4 colors on Sheet2. Lets say then J2 is $100.00, J3 is $500.00, J4 is $600, and J5 is $900.
What I would like to do it after the macro is run….
If looks at col J to see if there is anything in it. If so.. it puts the data from Sheet1 J1 and J2. Then it checks L on Sheet2 to see if there is anything there and so on. If there is not anything in the column then it does not put anything there.
Thank you so much!!!!!
Bookmarks