HELP!!!! for Excel

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
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?
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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

Active Member
Joined
Jan 13, 2002
Messages
424
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

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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

Board Regular
Joined
Mar 20, 2002
Messages
64
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.
 

Forum statistics

Threads
1,143,920
Messages
5,721,541
Members
422,369
Latest member
redinator

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top