Copying cell information

Question

Copying cell information

Closed

Report

Excel numpty - Aug 25, 2015 at 02:57 AM
TrowaD

Posts: 2829
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: November 22, 2021

- Aug 27, 2015 at 11:11 AM

Hello,
I would like to copy + add up the numbers in the cells. However when I change the filters, the numbers brought through change. The information is in the same file it is just on separate tab/sheet.
The example is below.
='TA 2015-16'!AI5+'BP 2015-16'!AI5+'RP 2015-16'!AI5

Please help, I would be very grateful for any suggestions.

Thank you all in advance.

Regards excel numpty.

Copying cell information
Formula for copying cell contents in excel - How-To - Excel
Excel insert copied cells multiple times ✓ - Forum - Office Software
Insert copied cells multiple times ✓ - Forum - Excel
Copying cells in excel from one worksheet to another ✓ - Forum - Excel
Suppose cell c5 contains the formula =b$6+c1. match each formula with its respective cell if you copied it. ✓ - Forum - Office Software

1 reply

Ask a question

TrowaD · Answer 1 · 2015-08-27T11:11:53-0400

Answer 1 / 1

TrowaD

Posts: 2829
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: November 22, 2021

490
Aug 27, 2015 at 11:11 AM

Hi Excel numpty,

Let the following pictures guide you towards the solution to your question and let us know if this works for you:

Unfiltered:

Filtered:

Best regards,
Trowa

Copying cell information

1 reply

Your reply

Subscribe To Our Newsletter!