Wednesday 13 May 2015

You have 5 nearly identical worksheets and the only thing you want to change between them is that data source?

A: You could: 

- Create worksheet 1 using data extract 1 
- Duplicate worksheet 1, replace the fields with fields from extract 2, by dragging them on top of the fields from extract 1 (replacing them all one by one.) What may work (but will be a little tricky): 
- Open your workbook and make sure you have connections open to all of the 5 extracts and then save the workbook 
- Open the workbook in a text editor (it's in an XML format) 
- Replace the references from data extract 1 to data extract 2
- Make sure you have a backup, and maybe try it with a simpler example with two extracts first.

Another approach:
 - Can you combine the data into one extract and use a filter one each worksheet?


No comments:

Post a Comment