button on the sheet to run code

Encerrado Postado há 4 anos Pago na entrega
Encerrado Pago na entrega

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 Arquitetura de software JavaScript

ID do Projeto: #23874974

Sobre o projeto

24 propostas Projeto remoto Ativo em há 4 anos

24 freelancers estão ofertando em média £25 nesse trabalho

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 Mais

£100 GBP in 2 dias
(429 Comentários)
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 Mais

£20 GBP in 7 dias
(212 Comentários)
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 em 1 dia
(132 Comentários)
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 em 1 dia
(257 Comentários)
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 Mais

£15 GBP em 1 dia
(135 Comentários)
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 Mais

£20 GBP em 1 dia
(188 Comentários)
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 Mais

£13 GBP em 1 dia
(118 Comentários)
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 Mais

£20 GBP em 1 dia
(89 Comentários)
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 em 1 dia
(17 Comentários)
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 Mais

£15 GBP in 7 dias
(6 Comentários)
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 dias
(13 Comentários)
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 em 1 dia
(19 Comentários)
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 Mais

£20 GBP em 1 dia
(17 Comentários)
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 Mais

£15 GBP em 1 dia
(21 Comentários)
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 dias
(15 Comentários)
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 dias
(13 Comentários)
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 em 1 dia
(6 Comentários)
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 Mais

£14 GBP em 1 dia
(6 Comentários)
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 dias
(0 Comentários)
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 Mais

£15 GBP em 1 dia
(1 Comentário)
0.0