Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If then copy to
Here is my issue, I have a very large workbook with lots of columns and rows
in lots of worksheets. I need one of the worksheets to search the data in two columns that meet specific criteria and copy those cells into a blank column. Something like this: if date in column a is = today's day minus 5 years and name in column b=joe, sally or james, move cells to column c Any suggestions out there? Thank You, -- maggiesteele |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If then copy to
Hi,
You really need a macro to do this. If you need help writing it, you'd have to supply some more detail. ie. Sheet names. Cell References of all data you wanted sorted. Cell References for the destination of the sorted data. Also, the date criteria: do you really mean Today minus 5 years (ie 16-May-2003 only) or do you mean any date less than 5 years old? Regards - Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel |