I have an Excel spreadsheet with two tabs - one tab is a list of sales data (eg. date, amount, customer name, invoice number) and the other tab is where I want to make very very simply invoices (they aren't actually being given out).
Each invoice is just 11 rows (eg. the first few rows are company name, address etc). For the date, its
=data!C6, for the invoice number its
=data!H6, for the amount its
When I highlight the
invoice (11 rows, 8 columns) and use the little box at the bottom right corner to drag down to generate the other
invoices automatically, it works BUT the problem is Excel is getting the wrong values from the data tab.
For example, the next
invoice should be
=data!G7 but instead its getting the data
Can someone please help me so that I can make it get the data one row at a time from the