Input Data/Output data in separate sheets

[boyboyboy]

ALL,

i NEED help. I am trying to figure out how to create a formula or macro to calculate data and record it to another sheet with a timestamp.

Sheet 1:
defines current number and calculates added values. but once added, it updates current number and records added value to sheet 2 with timestamp

input output.xlsx

[nilem]

maybe so (in the module of sheet "INPUT SHEET")

Please Login or Register  to view this content.

[benishiryo]

hi there, welcome to the forum. i'm assuming your Sheet 1 only consists of A1:B2 & the rest are for illustration? if so, try:

Please Login or Register  to view this content.

or maybe a change without even clicking the macro:

Please Login or Register  to view this content.