| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find values in multiple cells and paste row values
I have a project consisting of a "job sheet" and a "work details" sheet for
each day (jobsheet - Monday, Work Details - Monday etc). I am trying to take all information from the jobsheet with job code "EOD" in "N6" and put all the information on the work detail sheet with the job code being in "G14". I also then need to get the Reg No from "F6" and other work carried out from the same row, and put this on the work details sheet too with Reg No going in "E14". It is so long since I have done anything like this, and I have forgottoen so much. Is this better with formulas in each cell on the Work Details sheet, or using a Macro? Can anyone please help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I paste multiple values into one cell? | Excel Worksheet Functions | |||
| to find change and paste existing values/rows in excel with help of form | Excel Discussion (Misc queries) | |||
| Can you copy multiple tabs from formulas to values w/o paste spec? | Excel Worksheet Functions | |||
| Find values from cells in multiple sheets | Excel Worksheet Functions | |||
| Can you paste values on multiple worksheets at one time? | Excel Worksheet Functions | |||
Threaded Mode
