carolinafireworks
New Member
- Joined
- Dec 19, 2008
- Messages
- 17
I was trying to figure out a code that I can use. I want to use a macro or a code on close for the following. We do our invoices on Excel.
I want to create a back order sheet if the value's for Column I say BO. I want it to copy the values in columns A & B for each item that has BO in Column I. I would also like it to copy Cell C7 (which is our customers name).
We have a code that already saves our invoice on close as Cell C7 and the current date. I thought that there has to be a way to create a new invoice for this instead of having to manually do it every time.
I can e-mail a copy of what I'm talking about if someone would be so kind as to help me out. I don't know anything about using vba or macro's. I had someone else help me with the current codes, but it has been a couple of years & I have lost the e-mail.
Here's my e-mail ashleywhite_11@yahoo.com
I want to create a back order sheet if the value's for Column I say BO. I want it to copy the values in columns A & B for each item that has BO in Column I. I would also like it to copy Cell C7 (which is our customers name).
We have a code that already saves our invoice on close as Cell C7 and the current date. I thought that there has to be a way to create a new invoice for this instead of having to manually do it every time.
I can e-mail a copy of what I'm talking about if someone would be so kind as to help me out. I don't know anything about using vba or macro's. I had someone else help me with the current codes, but it has been a couple of years & I have lost the e-mail.
Here's my e-mail ashleywhite_11@yahoo.com
Last edited: