I am a beginner with macros and I am sure this would be a fairly simple code but I am really stuck.
I have excel 2007 (I don’t know if that is useful) I have an excel file that has 100+ sheets. I need to go through each sheet and make sure that each row corresponds to each row on every sheet (i.e. that total spending is always in row 10). Also, any sheet that doesn’t have a particular value needs a blank row as a space holder. The goal is to get the data to be used in sas.
I hope this is clear enough. I would really appreciate it if someone could explain the code that could make this possible.
