I have 47 sheets with the same data. I want to move the following cells from each sheet to one sheet so I can easily do an infile to SAS. The cells are:
B4, B5, B8, G13-23, I13-23, J13-23, K13-23, l13-23
Can anyone help me with a macro?
0
votes
I assume you mean you have 47 sheets with the same layout, not the same data, right? Also, where do you want the data to be on the output sheet?
– Bafsky
Yes we can help you with your macro, show us your macro and we will give you ideas of what to use for the gaps. If you just look for someone to program this for you completely I fear you misunderstood the idea of this website and suggest you to search for a freelancer somewhere else
– K_B
I cannot paste the code. It is too long. The macro record does work but it means going in and changing this section: sheets("1").select 47 times for each of the sheets and I have more folders than just this one. I am doing this with QTR 1 right now. sheets("1").select shows up 4 times in my macro so 47 * 4 means lots of time to do all this. there has to be a way to say sheets("1", "2", "3", on up to 47).select and do this at one time
– tina Miller
If you are planning to write a macro, you might just create a csv rather than putting it into another sheet.
– Robert Co
