Hi everyone,
I have an excel invoice that generates invoice for my customers.what i want is a macro that would copy date , invoice number and the invoice amount (these are in a1, g1, m10 respectively) to a different excel workbook located in d:\collection book\
i also want the data to be updated as soon as i create a new invoice (dynamically updated something like that)
i hope i am clear and you guys have understood ..
Replies highly appreciable
thanks and regards.