button on the sheet to run code

Closed Posted 4 years ago Paid on delivery
Closed 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

Excel PHP Visual Basic Software Architecture JavaScript

Project ID: #23874974

About the project

24 proposals Remote project Active 3 years ago

24 freelancers are bidding on average £25 for this job

schoudhary1553

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

£100 GBP in 2 days
(429 Reviews)
8.2
ksriniravi

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

£20 GBP in 7 days
(212 Reviews)
6.9
periyannas

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.

£30 GBP in 1 day
(132 Reviews)
6.5
mtdevil369

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

£15 GBP in 1 day
(257 Reviews)
6.7
nagyzoltan68

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

£15 GBP in 1 day
(135 Reviews)
6.6
rashedkhanrubel

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

£20 GBP in 1 day
(188 Reviews)
6.3
AnowarRatul

£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

£13 GBP in 1 day
(118 Reviews)
5.4
vsprybhanu

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

£20 GBP in 1 day
(89 Reviews)
5.7
reubengi

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

£20 GBP in 1 day
(17 Reviews)
4.7
BitzageTechHub

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

£15 GBP in 7 days
(6 Reviews)
4.4
webdesc

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

£70 GBP in 3 days
(13 Reviews)
4.3
MykolaDudych

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.

£10 GBP in 1 day
(19 Reviews)
4.2
MonisZafar

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

£20 GBP in 1 day
(17 Reviews)
4.4
eduuardo

Formula references can be changed with one click excel VBA button but why do you need to incorporate one more macro, when you are not a macro guru? It can crash or get unexpected results if treated unexpected way. All More

£15 GBP in 1 day
(21 Reviews)
4.1
nadeemgorsi

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

£50 GBP in 7 days
(15 Reviews)
3.8
omoretech

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

£15 GBP in 4 days
(13 Reviews)
4.0
NaliRaz

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

£15 GBP in 1 day
(6 Reviews)
3.5
whistler1987vw

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

£14 GBP in 1 day
(6 Reviews)
3.3
sanjaybhosaleit

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.

£15 GBP in 2 days
(0 Reviews)
0.0
jamoyat903

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

£15 GBP in 1 day
(1 Review)
0.0