Forum Discussion

Noa_Collins's avatar
Noa_Collins
Copper Contributor
Nov 06, 2023

Automatically Copy and Paste data from one column to another based on time

*DISCLAIMER*

Column A has been hidden with "Technician Names" to protect the innocent. (These are irrelevant to the question.)

So, I have a sheet that gets updated manually (Columns B:D). Column E updates automatically based on numbers entered in B:D. Cell B:19 has the current time displayed. This updates automatically after each manual update. Columns F:L have the results of Column E at the specific time (according to header label). 

Simply put, I am trying to figure out a way to have the results of Column E automatically pasted into the appropriate column depending on the the specific times.

(ie. if I'm updating columns B:D at various intervals throughout the day, I would like whatever the results were at the specified times (noon, 1PM, 2PM, etc.) to be automatically transferred to the appropriate column at the exact time specified.)

I've always been long-winded, so I apologize if there was a way to ask this question in less words. I just wanted to make sure I specified the details of my inquiry.

Your help would be greatly appreciated. I'm hoping that an answer to this question would teach me something that I might use in a future endeavor. 

No RepliesBe the first to reply