Microsoft Office Forums - View Single Post - Breaking down data in separate tabs

Thread: Breaking down data in separate tabs

View Single Post

Old

09-15-2016, 11:06 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,097

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

You must adjust the names d and Activity in the Name Manager so that they have sufficient rows. I have changed Activity to refer to A2:A1000 and d to refer to A2:H1000.

I can't replicate your second issue.

C11+C21+C30 (in Over View) is now equal to Data!D2

210. There was a fault in the formula in Audit INFO!D9.

Attached Files

Web Example_2.xlsx (110.6 KB, 10 views)

Reply With Quote