Hi Excel Forum,
My first query was solved successfully a while ago. So here is my latest question.
I have a table that contains all the the variations on my contract. The table also contains the information of how the variation will impact the costs of the project. (The table thus contains all internal reporting data)
I have a second table that contains the same basic data as table on, but this one I use to claim the revenue from the client. (I use a second table as table 1 contains confidential information I don't want the client to see)
My question is How to create the second table so that it is dynamic, so that when I enter the basic data in table 1 if is automatically reflected in table 2. (I can do this if I default the able to a specific size, but I would prefer the table to be only as big as required. i.e. if there is only one variation i only want the table to be one line long)
I only want to enter into the "salmon" coloured cell. On the claim tab I would only like to have to enter the claim qty.
Thanks
Quintin
Bookmarks