Closed

button on the sheet to run code

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

Skills: Excel, PHP, Visual Basic, Software Architecture, Javascript

See more: vbnet click submit button webbrowser page code, vba code update sheets excel, formula function excel, run code web page refresh, link button algorithm source code, visual studio radio button checked example code, excel formula function sheet, automatic run code php, daugmans rubber sheet model code, zip code mile radius formula, add cart button dont run virtuemart, button click counter code, arm run code ram, clicking button web page code, send worksheet formula function, custom code metastock external formula buy, code make function search site, google sheets button to run script

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #23874974

25 freelancers are bidding on average £24 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
(396 Reviews)
8.1
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
(204 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
(119 Reviews)
6.4
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
(127 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
(174 Reviews)
6.3
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
(117 Reviews)
5.7
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
(87 Reviews)
5.7
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
(86 Reviews)
5.1
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
ravinderkumar248

Hi Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o More

£30 GBP in 2 days
(21 Reviews)
4.6
akritisood94

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

£30 GBP in 1 day
(33 Reviews)
4.5
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
(18 Reviews)
4.2
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
(11 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
(9 Reviews)
3.8
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
(18 Reviews)
3.8
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
(9 Reviews)
3.9
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
(12 Reviews)
4.0
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
(14 Reviews)
3.7
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
(5 Reviews)
3.3
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
(1 Review)
1.8