Moving cells from one tab to another

[bradtheboywonder]

Hi Guys,

Long time lurker, first time poster. I know the title may not make sense, but this is what Im wanting to do:

* I'm trying to make a spreadsheet where each tab at the bottom is a day of the month (so 31 tabs in total) - This is the easiest part

* I now want to create a spreadsheet where I can enter date on say the 1st, then have a drop down box that have review dates (4 days, 7 days, 10 days), so when you click "4 Days" all the data from that row will move from the 1st to the 5th, thus meaning I can review it again in 4 days time.

I hope this not only makes sense, but is possible as well.

 

[Andrew Poulsom]

Welcome to MrExcel.

Why don't you put all your data on one worksheet with a column for the date? Then you can change any date and use Excel's built-in Sort and AutoFilter features to examine the data in any way you want.

 

[bradtheboywonder]

Welcome to MrExcel.

Why don't you put all your data on one worksheet with a column for the date? Then you can change any date and use Excel's built-in Sort and AutoFilter features to examine the data in any way you want.

Because that's the logical thing to do lol. I tried to sell that to them and they said no, that what they have pitched to me would suit them better.

So Im thinking, rather than move a row from one tab to another, is it easier/possible to get a macro that copies Row 1 (for example) and pastes that information into the last unused row in Tab 2?

 

[Andrew Poulsom]

Copying wouldn't be any easier than moving.