button on the sheet to run code
£10-20 GBP
Paid on delivery
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
so
week 1
c10 = 6
d10= 1-5-20
week 2
c10 = 9
d10 = 2-5-20
e10 ='Prevsheet!c10' (='week 1'!c10)
f10 ='Prevsheet!d10' (='week 1'!d10)
week 3
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
Project ID: #23874974
About the project
24 freelancers are bidding on average £25 for this job
Hello, I can help you with your project - button on the sheet to run code I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed More
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the existing file with data and code to duplicate sheet and change t More
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
Hello, I would like to work on your project. I have a great experience using excel macros / VBA, data formatting and data manipulation in excel. In order to complete this work, I will need sample data with some records More
Hi, I will make function and button to copy and generate weekly sheet as per your requirement with good and professional quality without any error. I have completed more then 100 project within 8 months with 5 star re More
£13 Only ------- In just 2 Hours ------ Excel Pivot Table, Chart, Graph, VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting ----- I can build the button to run all formula, please messag More
Hi, I will create a button to execute this code. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your p More
Hi there, I can setup the sheet for you to do this. I have good experience in XL and will deliver it. Warm regards. Reuben
Greetings, my name is Ahmad. I am Head of Client Relations and a web-developer myself. I would love to have an opportunity to discuss your project with you. With over 5 years of experience in mobile/web design and de More
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
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.
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with VBA scripts. It will be quick and accurate. If interested, we can discuss this further on More
Hi, there, I'll read your job description if you ping me, Interested in this job, and have experience in Google Apps Script, Sheets... Thanks
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
Hello. I'm just starting with my freelancing career, but I have a lot of experience dealing with automation and scripting. This task is easily solvable using VBA. And yes, you can have a button that will trigger the More
As per your requirement project will be completed. You will be satisfied with my work and confidently you will continue getting work done from me here onward.
I READ YOUR POST I CAN DO IT FOR YOU Hello I am a senior developer. I want to do it for you if you want. we can discuss more about this project. if you can send a reply. I waiting for you best response. let me discuss More