Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Data to a new sheet
Select your data,
Do Data=Filter=Autofilter in the dropdown for the column that contains the date, select custom, then select Greater than or equal to, then enter the date for the criteria Only the rows meeting the criteria will be visible. Select all the data, do edit=Copy mover to the new sheet and do select A4, then do edit =Paste Only the visible rows will be copied in xl97 and later. If you need code, turn on the macro recorder while you do this. Then adjust the code to make the criteria 7 days later than the current date and otherwise modify it to meet your needs. You turn off the data filter by doing Data=Filter=Autofilter (which acts as a toggle). -- Regards, Tom Ogilvy "MrAlMackay" wrote in message ... Is it possible to run a macro that will do the following: 1) Copy all rows where the date is = 7 days less than today 2) Paste in a new sheet on row 4, sheet called "Completed Dates in week". Appreciate your help on this. Many Thanks, Al Mackay ( ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
copy data of two cells from Sheet 2 into one cell in Sheet 1 | Excel Worksheet Functions | |||
Copy/filter data in a sheet from another sheet | Excel Discussion (Misc queries) | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions |