Please Help (Macro) or any other way

M

Mike

Hello,
Could someone please help me with a macro that will insert a row between
Groups
of Numbers. I would like to be able to insert a row between >=10000 and
<=19999,
=20000 and <=29999, >=30000 and <=39999, >=40000 and <=49999, >=50000 and<=59999 and so on upto 100000. I export this from Quickbooks and have to insert rows manually

Thanks in advance for any help

Vender Parts UPC Item Description QTY
11003
15002
17000
18000
19000
19999
20000
21000
25000
26000
26010
 
B

bony_tony

I'm a little unsure of where exactly you would like to insert a row.
There will be lots of rows between 10000 and 19999 for instance (11003,
15002 etc)
Do you want to seperate the 10,000's?
ie;
19000
19999

20000
21000
29456

30054
32487

?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top