Hello,
I am trying to create a macro to copy data from one sheet to another. The first sheet has data that has been entered and the second sheet is used organize the data so it can be used to make calculations and graphs from the data. The problem that I am having now is being able to define the the first empty cell in the organized data sheet so I can copy and paste to relative positions from it.
I am looping through the entered data sheet because there is not a set number of sets of data. The data in entered data for each entry is 9 rows by 27 columns (A2:AA10) and the converted code is 30 rows by 20+ columns. I am using column B, first row of each data entry in Enter Data, and column A, first empty row in Converted Data, as the baseline boxes from which ranges are selected relative to... if that all makes sense.

Please Login or Register  to view this content.
Is this even possible to do?
Thanks in advance.