Tidy up and sort data
Posted by Jeremy on June 02, 2000 6:08 AM
Is there a Macro that can move text to another column or columns if the 1st column of data exceeds a certain amount of rows.
Eg. I have text in column A (commencing from cell A2). in which the amount varies (could go down to Row 65336).
So if the data goes past row34 the remaining data is moved to column B (B2) until row 34 and again if any data goes past row 34 that goes to column C as so forth.