Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default Linking rows on multiple worksheets

I have a database that uses multipe worksheets to store data entered from a
userform I created. On each worksheet the first 4 columns are the same but
the rest are different, what I want to know is if it is possible to make it
so that if I were to move a row in worksheet 1 from row 20 to row 10 is it
possible to make it so the same row in the other worksheets would also move
to row 10 instead of still being in row 20.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default Linking rows on multiple worksheets

It would probably be more practical to use a For ... Next loop and move the
rows withing each workbook individually with a cut and insert and attach the
code to a button so you can call it when needed.

"aintlifegrand79" wrote:

I have a database that uses multipe worksheets to store data entered from a
userform I created. On each worksheet the first 4 columns are the same but
the rest are different, what I want to know is if it is possible to make it
so that if I were to move a row in worksheet 1 from row 20 to row 10 is it
possible to make it so the same row in the other worksheets would also move
to row 10 instead of still being in row 20.

Reply
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
Linking multiple Worksheets Jill Excel Discussion (Misc queries) 1 October 26th 09 08:12 PM
Linking from multiple worksheets slindergren New Users to Excel 0 April 16th 08 02:12 PM
Linking multiple worksheets mikebean97 Excel Worksheet Functions 2 July 21st 07 12:36 PM
linking multiple columns onto multiple worksheets talderman Excel Discussion (Misc queries) 3 August 23rd 06 02:00 AM
Linking multiple worksheets Ralph Excel Worksheet Functions 1 October 14th 05 11:32 PM


All times are GMT +1. The time now is 04:05 AM.

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"