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
 
Last edited:

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Watch MrExcel Video

Forum statistics

Threads
1,118,872
Messages
5,574,750
Members
412,617
Latest member
mlharris
Top