I have a work book with the water data for a handful of buildings. Each building has its own page. and each row on the page corresponds to a date with previous amount current amount....
I want to create another page that summarizes the activity of the activity of all the buildings for the past week and replicate that row. i imagine the code would be something like:
if(today()<date column + 7,'(info from cell in other page)',"")
the bold is the part i don't know how to handle because i want it to check every entry in the date column as well as the corresponding rows to what might have been this past week are different on each sheet
i hope this makes sense
thanks!
I want to create another page that summarizes the activity of the activity of all the buildings for the past week and replicate that row. i imagine the code would be something like:
if(today()<date column + 7,'(info from cell in other page)',"")
the bold is the part i don't know how to handle because i want it to check every entry in the date column as well as the corresponding rows to what might have been this past week are different on each sheet
i hope this makes sense
thanks!
