Excel

Resolved · Urgent Priority · Version 2010

Fri 27 Oct 2017, 19:50 Delegate Lucy said...

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

Tue 31 Oct 2017, 09:22 Trainer Jens said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips