We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Excel 2000 - crossing multiple sheets?
WishICouldFindMySlippers
Posts: 99 Forumite
in Techie Stuff
Using Excel 2000, is it possible to use data from a different sheet but in the same file in an equation?
EG: B5 (sheet 2) = A6 (sheet 1) x C2 (sheet 3)
Or is it better/easier/possible to do it across different Excel documents?
EG: B5 (sheet 2) = A6 (sheet 1) x C2 (sheet 3)
Or is it better/easier/possible to do it across different Excel documents?
Sealed Pot #355 - £162.29 (£150 banked) / £355 46%
Virtual Sealed Pot #159 £11.75
Nielson Mobile Rewards: £10 Argos vouchers
Consumer Pulse: £50 Argos vouchers
SwagBucks: £40 Amazon
House Deposit: £3600/£8000 45%
Virtual Sealed Pot #159 £11.75
Nielson Mobile Rewards: £10 Argos vouchers
Consumer Pulse: £50 Argos vouchers
SwagBucks: £40 Amazon
House Deposit: £3600/£8000 45%
0
Comments
-
Perfectly possible. The syntax is:
Sheet2!A1
which would look at the cell A1 in Sheet2. So your formula would be
=Sheet1!A6*Sheet3!C20 -
Cracking, cheers mate
Sealed Pot #355 - £162.29 (£150 banked) / £355 46%
Virtual Sealed Pot #159 £11.75
Nielson Mobile Rewards: £10 Argos vouchers
Consumer Pulse: £50 Argos vouchers
SwagBucks: £40 Amazon
House Deposit: £3600/£8000 45%0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards