troubleshooting Question

VB Macro to add 17 data rows (on different sheet) for every 1 manual row added (on a different sheet)

Avatar of Vrinda Vasudeva
Vrinda Vasudeva asked on
VB ScriptMicrosoft ExcelMicrosoft Office
18 Comments1 Solution145 ViewsLast Modified:
Hi all,
Please I would really appreciate your help here.
I have attached the sample excel file with sample 17 rows added (on 'Add Rows' tab) for 1st row in tab 'Source Data'. I need a macro that basically inserts 17 data rows on tab:'Add Rows' based on every 1 data row added on tab: 'Source Data'. Header Data remains same on tab 'Add Rows'.

For the 17 rows added on tab 'Add Rows' I need below values:
(1) Column 'Item Number': Same value as B2 (tab Source Data) appearing 17 times.
(2) Column Attribute Name: Same values as example provided (from Parent ID to Price Quantity)
(3) Column Attribute Value:
- C6 (Extended Price): $ sign + same value as H2 from 'Source Data' + AUD
- C7 (Item Category): Standard (remains same does not change)
- C8 (Material Group): relevant value from C2:C15 (tab: Material Groups) depending upon M2 in tab Source Data.
- C14 (Supplier Part ID): same as F2 from tab 'Source Data'.
(3) Column Display Text: Same values as example provided (from Parent ID to Price Quantity)
(4) Column Type: Same values as example provided (from Text (single line limited) to Whole Number)
(5) Column Description: Same value as B2 (tab Source Data) appearing 17 times.
(6) Column Is Term added from Item Master: 'No' appearing 17 times
(7) Column Formula: Blanks 17 times

Many thanks!
Expert-Exchange_Template.xlsx
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros