Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2010

Lucy has attended:
No courses

Excel

Hi
I hope someone can help me please?
I am creating a stock control spreadsheet and need help assigning a number to a cell that is connected by a hyperlink to another page, but I need the number in the hyperlinked cell to multiple by the previous cell to give a used number & it total with other numbers to a collective Total?
Am I asking too much & do I need to simplify what I'm trying to do?
Many thanks
Hopefully
Lucy

RE: Excel

Hi Lucy,

Thank you for the forum question.

You write that you are using a hyperlink, but I have a feeling that you mean that you have a linked cell.

If you have a linked cell, the formula bar will show something like ='the name of the sheet'!B3 .If the cell reference is B3. Click after what you have in the linked cell and type * (asterix) and then click on the previous cell.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 6 Nov 2017: Automatically marked as resolved.

Excel tip:

Removing the Ribbon from view in Excel 2010

At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.