LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H
 
Posts: n/a
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Cells Medusa Excel Discussion (Misc queries) 1 May 6th 05 09:05 AM
Excel should allow cloaking of certain cells when copying cells b. LDI Woody Excel Worksheet Functions 1 March 11th 05 04:55 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM
Copying formula to different cells L/P Excel Worksheet Functions 2 December 30th 04 10:37 PM
Automatic copying data excluding blank cells Wesley Excel Worksheet Functions 6 November 30th 04 01:17 AM


All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"