LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 36
Default Pulling/Collating Data

Hi,
I have a workbook with 31 sheets (diary)
A9:F9 (and other rows) is the info I want with the employee's initials in G9
There are multiple entries for the employee so he may reappear in row 13 and
15

I want to pull all the lines that relate to that employee from the 31 sheets
into a separate workbook

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Collating Data from Many Worksheets Within a Workbook Confused_in_Houston[_2_] Excel Discussion (Misc queries) 1 November 6th 09 09:16 PM
Pulling data from other wb based on data to populate dropdown list Suzann Excel Discussion (Misc queries) 0 April 23rd 09 04:29 PM
collating data wildauk Excel Discussion (Misc queries) 2 May 25th 08 11:50 PM
Help collating data from multiple worksheets Mediaid Excel Discussion (Misc queries) 0 August 21st 06 02:40 PM
collating Data Paul Cooke Excel Discussion (Misc queries) 0 December 5th 05 04:29 PM


All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"