Automatically updating multiple Excel worksheets from one "master" worksheet?
July 9, 2009 11:54 AM Subscribe
How to automatically breakout Excel worksheets based off one "master' worksheet?
posted by entropicamericana to Computers & Internet (9 answers total) 1 user marked this as a favorite
I inherited an Excel spreadsheet that is being used to to track individual orders. It is built so each order has its own row and the columns reflect various information (i.e. state)
My boss wants data entry done on the "master" worksheet. Then he wants the other sheets to automatically update given certain criteria. (For example, all orders placed in California.)
Let's say the state column is Column A and the values are simple two letter postal codes.
How would I write a function that would say if A2 is CA, then paste 2 here and if A2 is not CA, go to row 3 and check for CA?