Autofill without macro or VBA

mbrooks1009

New Member
Joined
Feb 11, 2025
Messages
8
Office Version
  1. 365
Platform
  1. Windows
Hello Everyone,

I am trying to make a BOM template. In one tab I have a part selector list which includes Part number in A16, part description in B16 and quantity in J16, Then I have 7 columns each with a different line( our projects can be several projects in one that is why we break it down by manufacturing line). I also have tabs for each line and a tab for total of parts required. What I wish to do is, when a quantity is filled in for a any part it automatically copies that part number and description to the associated line tab and also populates the total parts tab. This allow us to have a separate BOM per line and a total of parts needed for the entire project. I cannot use macros and have no knowledge of VBA. Looking perhaps for a formula that may accomplish this.

Thank you
 

Forum statistics

Threads
1,226,837
Messages
6,193,254
Members
453,784
Latest member
Chandni

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