| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
please help me keep my hair.......
Happy new year to you all.
I have a worksheet Job Sheet Monday! which has details of all work carried out, listing all the different services done. I need to extract all Reg No from F6:F29 that have a company code of 1 in C6:C29 and when the corresponding cells in the job code column V6:V29 are showing X These are to be listed in worksheet Work Details Monday! with the Reg No in E14:E27 and the cells in AA14:AA29 need to show a 1 when the corresponding cell in E17:E27 is populated. I also need to transfer other services done on the same reg no from the first sheet to the second if the same rules above apply with columns running up to BS but I want to get the first part working before I sort that. Thanks in advance for your help, I am quickly losing my hair over this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nudge entry just a hair | Excel Discussion (Misc queries) | |||
| Pulling my hair out here | Excel Worksheet Functions | |||
| Ripping my hair out, please help! | Excel Discussion (Misc queries) | |||
| tearing my hair out can it be done | Charts and Charting in Excel | |||
| Pulling hair out with VLOOKUP | Excel Worksheet Functions | |||
Threaded Mode
