Hi All,
In my daily sheet we update on a regular basis. there are 80 almost 80 codes. what I want is that I want a button on my daily sheet which we will automatically update my test sheet.
For example I have 3 transaction for a code F0101. Now when I click these 3 transaction will come up automatically in my test sheet.
then Go for Next code F0102. if there are 2 transaction similarly it will add 2 rows and update this block and so on.
I have written the code and for first code F0101 it is working. But how do I variable for my next code? . you can access the file is here for my next code how do i declare the variable that it should be strat from the next to next cell. Please help me.
I need your help. File is here. you will get a button on daily sheet, by clicking on these you will get the update on the Test sheet. But for my second it should be come from the very next cell bot not coming
https://app.box.com/s/xm44e9jc3jqu4tx0m9x1u08gaoe14bp6
let me know if you any question(s).
In my daily sheet we update on a regular basis. there are 80 almost 80 codes. what I want is that I want a button on my daily sheet which we will automatically update my test sheet.
For example I have 3 transaction for a code F0101. Now when I click these 3 transaction will come up automatically in my test sheet.
then Go for Next code F0102. if there are 2 transaction similarly it will add 2 rows and update this block and so on.
I have written the code and for first code F0101 it is working. But how do I variable for my next code? . you can access the file is here for my next code how do i declare the variable that it should be strat from the next to next cell. Please help me.
I need your help. File is here. you will get a button on daily sheet, by clicking on these you will get the update on the Test sheet. But for my second it should be come from the very next cell bot not coming
https://app.box.com/s/xm44e9jc3jqu4tx0m9x1u08gaoe14bp6
let me know if you any question(s).