| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create new sheets from data in either of two columns
I am a novice excel user but need help with a macro. I have a
spreadsheet with 21 columns A to U on sheet 1. I would like if information is entered into column C or column F the row, Column A to U would be copied to new sheet with name of the data found in either column C or F. If the name sheet already rewrite to the named sheet. The header row is A2 to U2 Data is in A3:U382 There will be a maximum of twenty different text values in the C and F columns. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
| Create a list of data from same cell but different sheets | Excel Discussion (Misc queries) | |||
| How do I create a summary worksheet that references data in other sheets? | Excel Worksheet Functions | |||
| create a data-series based on two different columns of data ? | Charts and Charting in Excel | |||
![Campbell[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
