Consolidate or What

A

agoodson1956

Board Regular
Joined
Sep 1, 2016
Messages
140
I have a TAB called KITTING. This TAB has the totals from 7 other tabs. The TABS are labeled STN, MDF, BACKBONE, CCTV, FIRE, ACCESS-IDS, PATH. Each of these TABs have the top row with PART NUMBER (B3), DESCRIPTION (C3), MANUFACTURER (D3), QUANTITY (E3), UNITS (F3).

I would like to also add a section directly below that would consolidate this information if there is no QUANTITY as it is a 1 for 1 right now and many lines have no information.

CCC.jpg
 
Last edited by a moderator:

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You must log in or register to reply here.

Similar threads

C
  • Question Question
Total Specific Sections in Auto-filled Spreadsheet
Replies
3
Views
274
Cubist
Cubist
H
  • Solved
Filter function, adding another variable inside as a range
Replies
5
Views
476
Fluff
Fluff
gheyman
  • Question Question
Go to a tab before the code is executed
Replies
1
Views
494
Anthony47
A
F
  • Solved
What If analysis to calculate the effect of new pricing
Replies
6
Views
1K
fielding
F
W
  • Solved
LOGIC Function, Year Help
Replies
1
Views
426
FormR
FormR

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top