HELP with excel 2002 formula

[jasona45]

Is there a formula to do this? I would like to extract a specific user and information below from multiple worksheets and put into new worksheet from one excel document.


(Computer Name User Name First Name Middle Intial Last Name Day of Week Month Day of Month Year Time)

 

[SkipVought]

Hi,

That's not something that a single formula does.

However, you could use the MS Query feature via Data/Get External Data/New Database Query - Excel Workbooks -- YOUR WORKBOOK -- YOUR WORKSHEET.........

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[jasona45]

Thanks but that wont just grab one user from each worksheet within the spreadsheet.

 

[SkipVought]

Why not? It all depends if you have stored your data in a proper table format.

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]

 

[jasona45]

I get error message "Data source contains no visible tables." I just have column headers.

 

[SkipVought]

In the Query Wizard -- Choose columns window, hit the [Options] button and check ALL Show Table Options.

Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]