ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Linking rows on multiple worksheets (https://www.excelbanter.com/excel-programming/404487-linking-rows-multiple-worksheets.html)

aintlifegrand79

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.

JLGWhiz

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.



All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com