PDA

View Full Version : Solved: Inserting cells in between entries



Klartigue
09-12-2011, 09:33 AM
On the attached worksheet, under the volume tab I would like to insert 3 blank cells everytime there is a new broker. For example, three blank cells in between F2 and F3, F3 and F4, F6 and F7, F8 and F9.

However, the number of entires per broker may change so I need a general reference that applies to different variations of this spreadsheet.

Thanks for the help! As a new user to VBA, i am figuring out a lot as I go along.

Klartigue
09-12-2011, 09:38 AM
Attachments currently not working..

Klartigue
09-12-2011, 09:47 AM
The spreadsheet corresponding to this post is attached