| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy if...or transfer if
Dear all
i have in sheet 1 a list of 3500 acounts where i have make clear of important and non important acounts that i need, by give them a simple color to the specific cell. Because there nothing to short them by color, at least i have not found anything yet, there is any way to use a formula or a vlookup to copy let say all the cells with yellow colour to sheet 2? I want to split the accounts by the color i have provide to the cells. Any ideas? Thanks in advance Manos |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer text w/o Copy&Paste | Excel Discussion (Misc queries) | |||
| Transfer $ of job#/Gl# on 1 s/s to 2nd s/s w/same Job#/Gl# <coord | Excel Discussion (Misc queries) | |||
| Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
| Transfer A Row From Sheet 1 To 2 | Excel Worksheet Functions | |||
Threaded Mode
