| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a row from one sheet to another and not all columns copy
I am brand new at this, sorry if I am not clear. I have a production
sheet in excel. What I want is on another sheet have the rows copy automatically when a date is put in column D on the production sheet, to the next available row on the other sheet, but I do not need all the columns. Out of 29 Columns in the production sheet I only need 6 of them copied to the new sheet. Example on the production sheet I have columns A-AC, when I add a date to column D in the production sheet I want only column D, F, H, N, T, and U to copy on the other sheet. When the information is on the other sheet it also auto sorts by column D of the new sheet. If anyone can help I would appreciate it. Thank You. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy columns when part of formula has another sheet in it | Excel Discussion (Misc queries) | |||
| How do i copy rows to columns on separate sheet, and have them upd | Excel Worksheet Functions | |||
| Macro to copy columns from 1st sheet to 2nd according to mapping-p | Excel Programming | |||
| Create copy of sheet using VB with columns in different order | Excel Programming | |||
| macro to copy columns to sheet | Excel Discussion (Misc queries) | |||
![Peaches[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
