| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sending rows to another worksheet based on value of cells in column A
:::Sorry for the duplicate post but didn't receive a reply so am trying
again :o)::: Hi everyone I have a worksheet that has 7 colmuns worth of data (it relates to team managers, of which there are approx 10 (name stored in column A) and other info regarding there team members. Each team manager is part of a service, e.g. Joe Bloggs is part of Revenues so I want all the rows that contain Joe Bloggs in column A to be transferred to the worksheet named Revenues. This needs to be done by code, by poss using a Command Button? Any ideas on this? As always, help is extremely appreciated!! Cheers Lindsey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum specific column rows based on 2 different column criteria | Excel Worksheet Functions | |||
| Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
| How do I prevent rows from duplicating when sending a worksheet? | Excel Worksheet Functions | |||
| Many Rows to One Row based off of first column | Excel Programming | |||
| Sending data in certain cells to another worksheet by pressing a button | Excel Programming | |||
![Lindsey M[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
