Forum Discussion

Floatyman's avatar
Floatyman
Copper Contributor
Oct 23, 2020

How do I inserts a calculated number of blank rows when data changes?

I'm printing some price tags from an excel spreadsheet. On the spreadsheet each row has store code, product and the sell price. In column A is a code for a store, in column B is the product and in Co...
excel
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Oct 26, 2020
But if you mean how to run this code in the worksheet. Then click from cell A2 (only possible in column A) and a message window appears where you can insert the number of rows. If it is, then sorry the translation is not the best 🙂 Thank you for your understanding and patience Nikolino I know I don't know anything (Socrates)
  • Floatyman's avatar
    Floatyman
    Copper Contributor
    Oct 26, 2020

    NikolinoDE Thank you for your help.  I paste the code in and Excel asks me to name and create a Macro, which I do.  Then Run, but see no difference so I must be doing something wrong.

     

    Attached is a file.  In column A, when the code changes I would like 10 blank rows (or ideally a number rounded to up a multiple of 6) to be inserted to separate these codes into groups on the sheet.

     

    regards

    • NikolinoDE's avatar
      NikolinoDE
      Platinum Contributor
      Oct 26, 2020

      Floatyman 

       

      Ready to use! 🙂

       

      Simply left double-click on column A (from A2) with the mouse and a user form will appear. There you enter how many lines you want and they will appear.

       

      Tested and it works for me without problems.

       

      I wish you continued success with Excel (the coolest invention since chocola... uh ... Microsoft! :)))

      And keep asking here - I just taught myself Excel with the help of this forum :).

       

      Nikolino

      I know I don't know anything (Socrates)

       

      * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here

Resources