I am new to macros. I have values in column A and a quantity in column B. I need to insert rows below the value in A based on the quantity in B. Also, the value in A needs to be copied into the new rows. If the quantity is 10, I need 9 more rows below.
EX:
40100 1
40101 3
40102 1
40103 4
needs to be:
40100 1
40101 3
40101
40101
40102 1
40103 4
40103
40103
40103
Any help with this matter would be greatly appreciated!!
Hi, scott,
one way could be a loop starting at the bottom and working up like
Please Login or Register to view this content.Please Login or Register to view this content.Ciao,How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
That absolutely wonderful! That works great, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks