Using the attached, can you help me write code that "says":
IF cell H2 = 1 than copy the "testrange" and paste it in the first blank column starting with column B on the "Sum" sheet (lined up with rows 5 to 28). So the first time the macro is run, it would paste the aforementioned range in B5:B28....the next in C5:C28.....and so on....
Any help would be much appreciated, and please let me know if you require additional details. I would preferably like to be able to hide the "Sheet with Ran" sheet and still have this work.
Thanks again,
JD
Bookmarks