Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I assume you have a column where you enter the date on what the item was picked up, if that is correct, apply filter to that column and select the blank cells, then highlight all the information you get, press CTRL + G, special, visible cells only, press CTRL + C, go to the sheet where you want to copy the information, press CTRL + V "equipment repair" wrote: I am a novice working in Excel. I am trying to start a new sheet and transferring information from the previous month. I only need the information on the equipment that has not been picked-up without having to redo a whole new document. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do you have 2 criterias be picked up in a lookup? | Excel Worksheet Functions | |||
how do you have 2 criterias be picked up in a lookup? | Excel Discussion (Misc queries) | |||
Setting up a list where an item can only be picked once in Excel | Excel Worksheet Functions | |||
Posts not getting picked up | Excel Discussion (Misc queries) | |||
Spell Checking - Special Words Not Picked Up by Excel | Excel Discussion (Misc queries) |