Copying cell information [Closed]

Question

Copying cell information [Closed]

Report

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

Posts: 2776
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: July 26, 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
Suppose cell c5 contains the formula =b$6+c1. match each formula with its respective cell if you copied it. ✓ - Forum - Office Software
Copying cond. format for entire row based on 1 cell to other row ✓ - Forum - Excel
Cells copying and pasting in a empty cell of another sheet ✓ - Forum - Excel
Excel insert copied cells multiple times ✓ - Forum - Office Software
Insert copied cells multiple times ✓ - Forum - Excel

1 reply

Ask a question

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

Answer 1 / 1

TrowaD

Posts: 2776
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: July 26, 2021

465
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 [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!