Microsoft Excel 2003 Help!

[Shooks]

Ok so I have a spreadsheet, and I want to create worksheets from it that will update based on the original spreadsheet. Is this possible?

For example I have Columns A B C D in my original spreadsheet.
Now in a worksheet called C all I want to show up is Columns A and C from the original and have these columns update if I change something in the original.

I am a total noob when it comes to excel, any help would be appreciated!

 

[yodigity]

Should be fairly easy. Just set cell A1 on workseet C "=Sheet1!A1" where "Sheet1" is the name of the original worksheet. Then copy and paste all the way down the A column on sheet C. Duplicate for column C (set cell B1"=Sheet1!C1").

If you don't want 0's to show up, use this slight modification to the formula: "=if(Sheet1!A1="","",A1)"

 

[Shooks]

thank you so much for the help, it worked perfectly, except for that formula. I tried to enter =IF('Master List'!M1="","",M1) and even though there is something in cell M1 of the Master List, it still shows up as 0. Any ideas?

Thanks again for the help.

update, never mind, I changed it to =IF('Master List'!M1="","",'Master List'!M1) and it works perfectly!! Thank you, you are a life saver!