Recent content by LostandConfused

They dont know how to set up a macro, and I dont want to have to set them all up only to do it again if it changes. I wanted an access database so that if someone requests a modification, I can do it once, or maybe even give it the capability of kicking out different types of products. Plus its...

I honestly don't know where the original comes from. We just get them sent to us about once a week from another organization, its completely raw and we end up reformatting it every time.

Thank you very much, I had to change things on it a little for a three part date as well as rewording a little because I kept getting errors. A lot of it is probably unnecessary but the fact that I was even able to understand it enough to do this makes me pretty excited, Thank you again. Oh and...

Oh and yes it works at least for a few more lines without that line included. There is just something about that line that is written funky.

Thank you for the reply. Sorry, it appears I missed some key info in my first post so I will try to answer them now. First the reason I can no longer continue with excel is because I was using access just for myself, with my own personal macro, but now my bosses have seen what I did with it and...

A while back I created an Excel Macro that converts a plain spreadsheet we commonly get into a format that makes it easy to track items and removes all the columns I dont use. Well recently people want that macro from other organizations, and since I cannot figure out how to explain to them how...