HELP!!!! for Excel

[imported_unknown]

While working in Excel, you have as many worksheets as you want. I know that, but I NEED TO KNOW HOW TO SEND INFORMATION FROM ONE WORKSHEET TO ANOTHER. SAY THAT I AM NAMED SHEET 1 DAILY AND SHEET 2 MONTHLY. I NEED SOME OF THE INFORMATION FROM DAILY TO SHOW UP ON THE MONTHLY SHEET. CAN ANYONE HELP ME?

 

[PaddyD]

Hi - welcome to the board!

It is very likely someone can help, but you'll need to be more specific about what data you have, what outcome your looking for etc...post back with more info.

Paddy

 

[imported_unknown]

On my daily worksheet I need the information from line c2 to show up on my monthly worksheet b2..... can you help me with the formula?

 

[PaddyD]

On 2002-10-01 22:42, Wings146 wrote:
On my daily worksheet I need the information from line c2 to show up on my monthly worksheet b2..... can you help me with the formula?

select b2 on the monthly worksheet, click the = sign in the formula bar, navigate to the other file & select c2, click OK...

Is this what you mean?

Paddy

 

[Fryer Tuck]

If I can jumb in here:
=Sheet1!C2
put that in b2 and you will get the value of cell C2 in sheet 1.

F.T.