LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mully
 
Posts: n/a
Default Moving without Pasting

Hi All

I'am a secretary of a federation of 10 clubs that are split in to 3 sections
North - East - West we race each week and I produce a result of trhe Open
Positions 1 -50.
The numbers 1-50 are in column A. In Column B are the Section Positions
e.g. 1 West and so on down to position 50 in Column A. There is a variation
that each section has at least some positions in the Open Result - West may
have 13 - East could have 27 and North 10. If I place 3 new tables on the
sheet Named - North - East - West each using 20 rows is it possible when
entering in column B the section and position say West 1 It will
automatically insert in the West Table at Position 1 - and on entering say
North 10 it would auto to position 10 on the North table and so on until all
tables are full at position 20.
I know this is long winded but it was the only way I could explain it.

Any Help Much Appreciated

Cheers ----- Mully
 
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
pasting or moving formula cells without updating formulas jake Excel Discussion (Misc queries) 2 April 14th 05 01:02 PM
Pasting numbers and formulas without pasting format. Dan Excel Discussion (Misc queries) 3 March 27th 05 03:47 AM
How to remove an extra line added by excel when pasting into notep CoolGuy Excel Discussion (Misc queries) 1 March 2nd 05 02:57 PM
Plotting moving average line on a chart Herbert Chan Charts and Charting in Excel 1 February 26th 05 08:31 PM
pasting into an excel template without losing the formatting chachi Excel Discussion (Misc queries) 2 January 14th 05 04:08 AM


All times are GMT +1. The time now is 10:28 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"