Hello
I have an excel worksheet with K Columns with info starting on Row 5 to 30
I would like to move a row to the second sheet if a date has been put under Column I which is called "Closed Date"
It will delete the row from Sheet1 and put it to the top row in Sheet2. For example the info from Sheet1 say Row 6 will be put into Sheet2 on Row 5 with the rest of the info moving down on sheet2 to allow for the inserted line to go in.
Is this even possible?
If not is it easier to delete it from Sheet1 and insert it at the next available row on Sheet2.
I am using Excel 2007 and am not very familiar with recording a macro so that wont work.
Thank-you for anyone who responds.
I have an excel worksheet with K Columns with info starting on Row 5 to 30
I would like to move a row to the second sheet if a date has been put under Column I which is called "Closed Date"
It will delete the row from Sheet1 and put it to the top row in Sheet2. For example the info from Sheet1 say Row 6 will be put into Sheet2 on Row 5 with the rest of the info moving down on sheet2 to allow for the inserted line to go in.
Is this even possible?
If not is it easier to delete it from Sheet1 and insert it at the next available row on Sheet2.
I am using Excel 2007 and am not very familiar with recording a macro so that wont work.
Thank-you for anyone who responds.