How to save cell data to several cells on another sheet

Good day!

I've been trying to help solve my husband's problem but to no avail. Pls help us.

His problem is about saving data of a cell that he must update every hour to several cells of another sheet. He must save each changes to individual cell automatically.

Ex.

All update is done on sheet1 and the result is on sheet1 B2.

The result of the 1st update on sheet1 cell B2 is 12:30.
12:30 must appear on sheet2 C2.
2nd update on sheet1 B2 is 1:15 so 1:15 must appear on sheet2 C3.
3rd update must be on sheet2 C4 then 4th on sheet2 C5 and so on.

Please help. I am new with excel.

Thank you very much!

aih-jah,

To get it to happen automatically is a bit tricky. There's the worksheet_change event, which only picks up if a cell is manually changed by typing into it. That event misses changes due to formula recalculations. The worksheet_calculate event can pick that up, but it picks runs everytime any cell is updated, so it would probably copy over far more than just the one update per hour.

As a more controlled alternative, I would suggest that a button form control be used instead with the following macro assigned to it:

Please Login or Register  to view this content.

Note:
-If the worksheet names are different, just change them to the correct names in the macro code

To put the macro in an Excel workbook:

1. Copy the code provided
2. Open the desired workbook
3. Press ALT+F11 to open the Visual Basic Editor
4. Insert -> Module
5. Paste the code

How to add a button form control in Excel 2007



Hope that helps,
~tigeravatar

Originally Posted by Mazzaropi

Dear aih-jah, Good Morning.

Is not possible to do this kind of procedure using Excel formulas.

You need to use VBA programming.

Hi,


You are right. Excel formula can't solve our problem unfortunately I'm not familiar with VB.

Thanks!

Hello

Thank you very much for the info.

Unfortunately I'm not familiar with VBA maybe it's time for me to try it.

Is there an easy way to study VBA?

I will try your suggestion.

Again, thank you!

hello
i try same come for miltiple cell copy on other sheet. it is work
but i want to also copy black cell to other worksheet with some special "-" sign.

can u help me .....