Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
brownsatan
 
Posts: n/a
Default Populate worksheets based on a master sheet


Hi there

I have a main sheet, this sheet is used to log calls for several
different managers.

these managers also have a seperate worksheet. Is it possible to
populate these sheets so it displays all the related rows from the main
logging sheet.

I have tried using a vlookup, but this returns the same row over and
over again.

Any help would be gratefully appreciated


--
brownsatan
------------------------------------------------------------------------
brownsatan's Profile: http://www.excelforum.com/member.php...o&userid=31218
View this thread: http://www.excelforum.com/showthread...hreadid=508918

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Populate worksheets based on a master sheet

Take a look at Data Filter AutoFilter..............

Vaya con Dios,
Chuck, CABGx3



"brownsatan" wrote:


Hi there

I have a main sheet, this sheet is used to log calls for several
different managers.

these managers also have a seperate worksheet. Is it possible to
populate these sheets so it displays all the related rows from the main
logging sheet.

I have tried using a vlookup, but this returns the same row over and
over again.

Any help would be gratefully appreciated


--
brownsatan
------------------------------------------------------------------------
brownsatan's Profile: http://www.excelforum.com/member.php...o&userid=31218
View this thread: http://www.excelforum.com/showthread...hreadid=508918


Reply
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
Master worksheet automatically enters data into sub worksheets Ken Excel Discussion (Misc queries) 1 November 1st 05 10:36 PM
Make inventory sheet to track, order & reduce quantity from master drc536 Excel Worksheet Functions 1 October 23rd 05 05:35 PM
Rollup worksheets into a master worksheet - automatically? Annabelle Excel Discussion (Misc queries) 0 October 18th 05 07:54 PM
How to populate one sheet with data from another sheet KH New Users to Excel 1 February 25th 05 06:21 AM
populate cells with data from another sheet Pepe_abu Excel Worksheet Functions 0 January 15th 05 08:51 AM


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

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

About Us

"It's about Microsoft Excel"