Hi all,
I am grateful for any help at all with this.
I have a pricing template for a project I am working on. On one spreadsheet tab that shows my resources loaded costs, bill rates and days. I have several pricing tabs like this.
The problem I have is I want to be able to create a dataset on a separate tab which is a datatable that I can collate the information from. I have tried using multiple consolidation ranges pivottable but got a bit lost...
<tbody>
</tbody>
The desired datatable I am looking for is the below and would like to know the optimum automated way of doing this and if I am better using links or pivots. Ideally pivots, so if rows are inserted it doesnt cause an issue.
<tbody>
</tbody>
If you can help, you are a life saver
Thanks and Regards,
Nick
I am grateful for any help at all with this.
I have a pricing template for a project I am working on. On one spreadsheet tab that shows my resources loaded costs, bill rates and days. I have several pricing tabs like this.
The problem I have is I want to be able to create a dataset on a separate tab which is a datatable that I can collate the information from. I have tried using multiple consolidation ranges pivottable but got a bit lost...
<tbody> </tbody> |
<tbody>
</tbody>
The desired datatable I am looking for is the below and would like to know the optimum automated way of doing this and if I am better using links or pivots. Ideally pivots, so if rows are inserted it doesnt cause an issue.
<tbody> </tbody> |
<tbody>
</tbody>
If you can help, you are a life saver
Thanks and Regards,
Nick