Add, delete & edit rows automatically

**Baziwan** · 06-12-2012, 11:16 AM

Hi, I have a large Database of products that is constantly changing. At the moment when I want to add, delete or edit products it is done manually. However I'd like to have macros do the tedious work for me, thus freeing up some of my time. If anyone can guide me in how I can get this done It would be much appreciated. I can't upload my database as it's just too large so I've mocked up a quick example so you can see the kind of thing I'm looking to have the macros doing from me. Once again, thanks in advance.

**Baziwan** · 06-13-2012, 05:17 AM

No takers yet. Just bumping it back to the front page so that it doesn't disappear into obscurity.

**arlu1201** · 06-13-2012, 07:19 AM

I will try and work out part by part for you. I may not be able to work out all 3 at the same time.

**Baziwan** · 06-13-2012, 07:51 AM

Thanks Arlette,

I was thinking that maybe a userform for each might be easier. What do you think?

**Baziwan** · 07-02-2012, 11:42 AM

Hi,

So I've been working on how to solve what I need doing with my excel document. Happy to report that I've solved Deleteing and Editing Products. The only one I'm stuck with is adding products as I want it to insert rows specific to information entered. This particular problem is beyond my vb skill level so I'm hoping that one of you genious gurus will take up the challenge of solving my problem.

**arlu1201** · 08-08-2012, 06:53 AM

Did you get this solved?

**Baziwan** · 09-14-2012, 08:25 AM

Originally Posted by arlu1201

Did you get this solved?

Hey Arlette,

Editing and Deleteing I managed to solve. With adding a product I came up with a workaround that does what I need it to do but is a little long winded for the user. Ideally I'd like the user to type the name of the product into the userform and select the type of product that it is. That's all I want them to input. The macro will insert the new product into that named range alphabetically.

If you want I can show you the work around?