dynaimcally organizing or copying cells?
 

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?

dynaimcally organizing or copying cells?
 

It sounds like =vlookup() or =index(match()) would work:

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))



Mike H wrote:

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?

--

Dave Peterson