'sending' multiple boxes to another sheet by 1 click

[joseph_pat]

Hi, i am working on a report sheet to make my life easier.

I have a sheet that i fill out daily, each day has numerous boxes with different information, i was wondering if there is a way to 1 click 'copy' this information to another sheet in a single row.

I have attached the sheet and a proposed result, only way so far is to = each box manually.

any help or directions will be much appreciated

thankyou

frmula.xlsx

[ufopilot]

This is a quick and simple copy of the formulas you've had. Upon clicking the button. it simply places the formula results into the area.
If you need to expand your selection, simply add on to the formulas, and ensure the code reads and copies all the newly added formula into the sheet.

[joseph_pat]

Hi ufopilot, thankyou so far so good.

Is there a way for me to choose which result sheet the a box will get pasted to?
Like for example if i was to click a button it would ask which result sheet to past to, also is there a way to choose different cells that will situated around the sheet (not yet decided were to put these cells)

Thankyou

[ufopilot]

joseph_pat,
I have tried to make this a simple step by step event, so you could edit it, should you need to:
Unhide columns N-X. These are the "formulae" that the code will copy and paste (the code then takes out the ".=" and changes it to "=" to make the formulas active). And last it will take the results, copy and paste the values only.
To Edit: change the formulas to what you want.
Right click on the button and select "assign Macro" - then edit - you should be able to read through the code and edit the code to copy what you want, where you want it.

[joseph_pat]

Hi FDibbins, thankyou for your reply, i understand it is not possible to 'send' date, would it be possible if i could formula (=cell 1 <i only need to click box but it copies a few cells in relation to that cell 1>)

If you remember the excel document we attached in the past, i have drawn an image of what i mean. So if i click on 7:30 it will also copy in the date, day and times

i-want-the-click-to-do-this.jpg