Hi there,
I am trying to create a summary column A on Sheet1 that takes column E from sheets 2-8 and forms one master list. Column E is a concatenation and the number of rows in column E differs from sheet to sheet, from month to month.
I thought I was doing great until I ran into an issue with pasting as a special value. My understanding is I have to use pasting as a special value with a range, but I don't understand how I can make the range dynamic.
This is where I got before I discovered the paste as special value issue (I practiced on a values only workbook).
Thanks for your help!
Bookmarks