I am working on getting numbers from certain sources and building out a report from the results. I have 4 variables that need to update a specific spreadsheet. The row they update will depend on the hour it is run. ColumnA will have certain hours in the following format: 7:00AM, if the job runs at 7:05AM it should input the variables into the 7:00AM row into Columns B,C,D,E respectively. Was wondering if there is any way to complete this as I am having a tough time. I can build out a database and input into the spreadsheet by specifying the specific cells but need this to be more dynamic.
Any help will be much appreciated.