Excel2007 - Convert Shared WB data to Table - Best Practice?

[RP1America]

Hi!

I have a shared workbook in which users input data (daily) into a tabular dataset.

I am looking to eventually create a dashboard from this dataset and as a first step would like to place the data in a Table. Since you cannot have Tables in a Shared workbook - what should be my next step? Please keep in mind, I would like this to be an automated task.

Should I export the data to a new workbook? Should I copy and paste the data to a new workbook? Does it even matter? Other? Are there pros and cons to certain ways of doing this? Am I even able to set up a Table via VBA once the data is in the new workbook?

Thanks!
Ryan

 

[SkipVought]

hi,

Query this data from another workbook.

faq68-5829

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lionelhill]

had you also considered Access as a tool for this job?

 

[RP1America]

Great! Thanks, Skip. I'll give that a try.

lionelhill - I had not considered Access as the data is already being entered into excel and I am looking to dashboard the data (which I am unaware of Access having that ability).