I was thinking that it may be easy to use loop to grab data in each roll instead of checking the different number of Quantity.
I found this code on the web that can copy additional rows for the number of Quantity.
Sub CopyData()
Dim xRow As Long
Dim VInSertNum As Variant
xRow = 1
Do While...
Hello, I'm new to the world of VBA and I need some help for coding.
I need the following set of data to be put into a report format as below;
Data Set
Report Format
What the report should look like;
Count the number of Orders and put the number in column A. For example there are total 3...