Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a workbook with eight tabs. The first tab is just a sequence of data,
A2:A61. There are three columns, Item, Description, and Tab. Rather than doing a lot of copy/pasting, I'd like to be able to put a number in the tab column and have the other two entries copied to the next available row in the associated tab in the workbook. This way, I can go down the column entering tab number and quickly sort and assign the data to where it belongs. Any suggestions? Can it be done without any serious programming? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying Cells | Excel Discussion (Misc queries) | |||
Excel should allow cloaking of certain cells when copying cells b. | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Copying formula to different cells | Excel Worksheet Functions | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |