Converting a range a Table

[Graemea]

Hi,

I have a workbook that consists of a number of worksheets containing data pasted in from other sources.

In the first sheet i have gathered data from the other sheets using VLOOKUP functions.

When the workbook is updated each month new rows may be added, or superfluous ones deleted, in this first sheet.

I would like to convert the data in the first sheet into a Table (using Ctrl + T) and keep it in that format for future monthly updates.

Is this a sensible thing to do and are there any pitfalls to be aware of?

Thanks!

 

[sdruley]

Hi,

I have a workbook that consists of a number of worksheets containing data pasted in from other sources.

In the first sheet i have gathered data from the other sheets using VLOOKUP functions.

When the workbook is updated each month new rows may be added, or superfluous ones deleted, in this first sheet.

I would like to convert the data in the first sheet into a Table (using Ctrl + T) and keep it in that format for future monthly updates.

Is this a sensible thing to do and are there any pitfalls to be aware of?

Thanks!

It would seem to me that you are trying to build a castle on top of quicksand. To solve this issue you need to go way up stream and ensure that the data coming in is a live stream. This way only one worksheet is needed as long as the worksheet is designed to meet Excels data base protocol. Use one of Excel's database import features. The data will automatically update.