say i have a sales invoice, which has inv no. in range d10, date in j10 and sales item list in the following range b19:n48. can i copy this live data from an active workbook to another workbook (which may be active or not). also the sales item list has 30 rows, but data can be in only 1 row or can be in several rows also.
most important if there are 3 rows of sales item data, then i need to copy the following to the other workbook - namely
d10, j10, b19 to n19
d10, j10, b20 to n20
d10, j10, b21 to n21 and then abort (and update again for the next new invoice, in the same manner)
how to do it. any help ???
most important if there are 3 rows of sales item data, then i need to copy the following to the other workbook - namely
d10, j10, b19 to n19
d10, j10, b20 to n20
d10, j10, b21 to n21 and then abort (and update again for the next new invoice, in the same manner)
how to do it. any help ???
