Copying cell information

Closed

Excel numpty - Aug 25, 2015 at 02:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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
If cell contains specific text then return value in another cell vba ✓ - Excel Forum
Run macro when cell value changes - Guide
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
If cell contains text then return value in another cell ✓ - Excel Forum

1 reply

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
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

Similar discussions

Excel - IF function with multiple words

How to use conditional format based on text?

Counting cells containing only numbers

Highlight cell if another cell contains any text

Removable Drive disappearing when copying

If cell = date return yes or no.

Similar discussions

Subscribe To Our Newsletter!