Hi everyone,
In cells D3:D6 I have several formulas, generating numbers.
I want to add a form control button (or something similar) which copies the above results into cells C17:F17, but the worksheet is designed purely to use on an Android mobile device - so I can't use VBA/Macros for this.
Does anyone know if there is a way to do this?
Many thanks in advance,
Andy
There is no way to do what you are asking.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I think you've answered your own question. You're looking to automate a task whilst at the same time acknowledging you can't use the only automation available to Excel.
Can't you just link C17:F17 to the relevant formulae cells? If not I guess you're only way is to manually copy and paste
Last edited by AliGW; 02-14-2018 at 01:44 PM. Reason: Unnecessary quotation removed.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks AliGW and Richard. So there is no way to execute a formula by using a button?
I was hoping to be able to enter a code into cell D3, which generates data in D4:D6, and then copy that data further down the worksheet so I can enter (say) 6 separate codes and generate 6 rows of data.
Andy
No - you would need code (a macro) to make the button work.
Why not enter your 6 values in D3:I3 and then link D4:D6 to D3, D7:D9 to E3, ....etc.
Thanks Richard, that's basically what I am now doing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks