Jack-P-Winner
Member
I want to be able to take the data that happens say in the 50+ SS sheet which will be in 1 book and whatever happens in this book I want it to do the same thing in the other sheet called LS.
Here is how it works:
If STUV goes up 1 digit for example 3:S goes to a 5 and row 2's counter goes from 4522 and becomes 5522 I want the 2 on the LS sheet's counter in 885:S to go to a 3 so row 884 would go from 2432 to 3432.. Whichever letter (STUV) goes up in one book/sheet I need the same letter (STUV) to go up in the other book/sheet
I have 4 books and in each book there are 20 sheets just like this. I want to be able to do this for all the sheets. the sheets are called the exact tsame thing, the only different is the amount of rows. (small book has 100 and large has 3000)
I have 2 different kind of books. 1 book will have the date in STUV and the other book will have the data in WXYZ
How would I write the formula for this?
https://app.box.com/s/rhumlb00tkjq2y7pddii
Thank you!!!
Here is how it works:
If STUV goes up 1 digit for example 3:S goes to a 5 and row 2's counter goes from 4522 and becomes 5522 I want the 2 on the LS sheet's counter in 885:S to go to a 3 so row 884 would go from 2432 to 3432.. Whichever letter (STUV) goes up in one book/sheet I need the same letter (STUV) to go up in the other book/sheet
I have 4 books and in each book there are 20 sheets just like this. I want to be able to do this for all the sheets. the sheets are called the exact tsame thing, the only different is the amount of rows. (small book has 100 and large has 3000)
I have 2 different kind of books. 1 book will have the date in STUV and the other book will have the data in WXYZ
How would I write the formula for this?
https://app.box.com/s/rhumlb00tkjq2y7pddii
Thank you!!!
