LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JCG JCG is offline
external usenet poster
 
Posts: 6
Default Selecting rows within a range

Greetings:

I'm developing a macro that will select all project numbers for an
individual in our organization. I hope to have a program/function that will
look at the data and select all project numbers "Project Number1 thru Project
NumberN for an individual and list it in individual cells on a sheet within a
workbook for that individual.

The data I want to extract is in the first column and the proper
program/funcition would identify all Project Numbers that are between Project
number (Header) and Total according to the format of my data shown below:

Staff Member Name1
Project number (Header)
Project Number1
Project Number2
Project NumberN
Total

Staff Member Name2
Project number (Header)
Project Number1
Project Number2
Project NumberN
Total

Staff Member Name3
Etc...

I'm greatful for any response.
--
Thanks in advance...j
 
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
selecting a range Garth Excel Discussion (Misc queries) 2 March 4th 09 08:40 PM
Please help with selecting a range keri Excel Discussion (Misc queries) 7 December 12th 06 08:56 PM
after selecting 50 rows of a column i can't reference the cells in the rows Bob Salzer New Users to Excel 2 July 21st 06 10:29 PM
Selecting range in list of range names depending on a cell informa Courreges Excel Discussion (Misc queries) 2 June 19th 06 10:59 AM
Selecting a Range SJT Excel Discussion (Misc queries) 2 March 8th 06 07:30 PM


All times are GMT +1. The time now is 01:48 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"