need a function to get data from the prevsheet like you can do in excel
I really would like this to work because the other option is for me to manually like each cell with totals to the same cell on the previous tab. i have to dose this for 52 weeks, a new tab for each week so when i duplicate the tab, i do not need to change the formula i have 30 to do on each sheet and a button on the sheets to duplicate sheet and rename sheet from a cell on the sheet
c10 = 6
c10 = 9
d10 = 2-5-20
e10 ='Prevsheet!c10' (='week 1'!c10)
f10 ='Prevsheet!d10' (='week 1'!d10)
c10 = 3
d10 = 9-5-20
e10 ='Prevsheet!c10' (='week 2'!c10)
f10 ='Prevsheet!d10' (='week 2'!d10)
and so on up to week 52
any help would be great
would this be script i need? not sure this is all new to me
also how would it work ?
could i make a button to run the code?
i already have some code to duplicate sheet and change the name of the sheet to 'week 1, week 2, week 3 and so on
25 freelancers are bidding on average £24 for this job
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.
Hi, I have understand the project requirement & interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss more & start the project. Thanks
Hi I am good in excel vba and i can create whole code from scratch rather than [login to view URL] can have a look over reviews .I can start right [login to view URL] we can discuss over chat. Regards
Hello :) I am interested in your offer and I am ready to cooperate. I have experience in writing macros VBA for Excel. I'm ready to start doing your assignment.
This is absolutely possible. Expert programmer having great experience working with similar applications. let's discuss further over chatbox. I can do this quickly and most effective way
Hi I can develop a desktop application for you where you can easily select the excel file and with single click on button you can get the results for all tabs, can I check your excel file? thank you
Hi, I can create your google apps script function in no time. Feel free to contact me over chat to discuss about your project & requirements. Best regards, Naly