ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   create a list dependant on info in a column (https://www.excelbanter.com/excel-worksheet-functions/146807-create-list-dependant-info-column.html)

Steve

create a list dependant on info in a column
 
Further to my earlier post i am trying to create a list automatically on a
worksheet drawn from other worksheets.

I have 12 monthly worksheets and a summary page

I want to get Excell to look in a column F on each month and if it has a
date in it pull the info from col A & B to create a liston the summary sheet


Max

create a list dependant on info in a column
 
See response to your last reply to Shane in your earlier posting, for one
way using simple non-array formulas to "pull up" the results in the summary
sheet.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steve" wrote in message
...
Further to my earlier post i am trying to create a list automatically on a
worksheet drawn from other worksheets.

I have 12 monthly worksheets and a summary page

I want to get Excell to look in a column F on each month and if it has a
date in it pull the info from col A & B to create a liston the summary
sheet




Steve

create a list dependant on info in a column
 
Cheers

will send that to the office and have a go

"Max" wrote:

See response to your last reply to Shane in your earlier posting, for one
way using simple non-array formulas to "pull up" the results in the summary
sheet.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steve" wrote in message
...
Further to my earlier post i am trying to create a list automatically on a
worksheet drawn from other worksheets.

I have 12 monthly worksheets and a summary page

I want to get Excell to look in a column F on each month and if it has a
date in it pull the info from col A & B to create a liston the summary
sheet





Max

create a list dependant on info in a column
 
Let us know how it went for you.
Post back in that earlier thread
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steve" wrote in message
...
Cheers

will send that to the office and have a go





All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com