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?
- 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