Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating cells in a workbook based on a criteria in another workbo
Good day,
I have a workbook with multiple tabs for different operations on the same tanks i.e. Tank 01 can have internal receipt, dewatering, jetty receipt etc. There are about 60 tanks and these operation occur every day with each tank experiencing a change in volume for each operation. The thing is, I created a new workbook in which I combine the operations in order to create a daily report of all tanks. But I find myself copying each column under the appropriate date for each operation into this new workbook. I want to know if there is a formula/function/macro I can use to update the columns daily in this new workbook based on the dates in the first wookbook. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically updating cells when opening workbook | Excel Discussion (Misc queries) | |||
Excel - making changes in one workbook so they affect other workbo | Excel Discussion (Misc queries) | |||
Insert text from another workbook based on criteria | Excel Worksheet Functions | |||
importing and updating list based on criteria | Excel Discussion (Misc queries) | |||
cells linked to others in same workbook not updating | Excel Discussion (Misc queries) |