| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy from one Sheet and paste on another sheet based on condition
Hi,
I have an excel sheet where on the Sheet 1 I have two columns (Resource Name and Task Assigned). And there are other sheets on the name of resources e.g. James, Williams. In the "James" sheet I have first column as Task Assigned" and then there are other columns. Similarly I have 8 similar sheets. My question is if in the Main Sheet I enter Resource Name (e.g. James) and Task Assigned as YYY. Then this task "YYY" should get pasted in the task column of James. And if I enter William in Resource Name column then the task assigned should get pasted in task column of sheet "William". I appreciate your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
| Copy and Paste based on Condition | Excel Discussion (Misc queries) | |||
| copy data to another sheet on condition | Excel Worksheet Functions | |||
| Copy certain cells from one sheet to another with a condition | Excel Worksheet Functions | |||
| Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
Threaded Mode
