calling cells from other sheets and listing

[louis2112]

Im trying to do two things and i uploaded the sheets so you guys can ge
a feel for what i am trying to do.

I want to know how do i call for the value of cells from differen
sheets from within the project.

also if you see the attachment, I want to be able to list all names o
people that have a value for a date and list them on a differen
sheet.

Thanks for all the help!

Loui

Attachment filename: schedule.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51639

 

[Patrick Molloy]

Please do not attach workbooks - they should not be
opened as we don't know what viruses may be inside. Also,
it cost money even to see the email let alone open it.
Explain your problem with as much detail as
possible...code examples and error messages are useful.

Your question seems too simplistic , so maybe I don't
understand it.

DIM MyValue as String
MyValue = Workbooks(x).Worksheets(y).Range(z)

where x,y and z could be explicit values or variables.

Your second question - have you tried using a data
filter?

Patrick Molloy
Microsoft Excel MVP

 

[Bob Phillips]

He didn't Patrick, he gave a link to a workbook on ExcelForum (not that I am
going to open that either).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[louis2112]

Ok, thanks for letting me know.

What the first thing im trying to tackle is when a value is entere
into my sheet
"Schedule" I want to carry that value over to other sheets.

For example.

C7 of sheet Schedule is value 4/20/2004

how can i carry that over to B8 of sheet "Monday"

The second problem is quite more a difficult problem. I want excel t
look through a range of numbers such as

=COUNTA(C$8:OFFSET(C20,-1,0))

and then where there are value take the names of the values which ar
in columm B and list them in a different sheet.

For example

On sheet Schedule. B7 value is Louis C8 is 1130.

when i do a range C8-C20 it finds that there is a value 1130, I want i
to pull the name B7 to another sheet.

If this is confusing I am sorry, I am basically trying to create
simple custom excel worksheet.

Thanks for all your help!



Loui