Hi guys,
I need to create a worksheet as a favour to a friend, and subsequently realised that I'm but a puppy with Excel and I need help. I've created a master sheet with each customer in a row, and by month B/f, Payment amnt, Paid amnt and Amnt Due in the columns. I then want an Invoice for the second sheet and a statement for the third sheet. I don't want to create an Invoice and Statement for each customer, so need to find a way to draw the info per customer row through to Invoice and statement, but don't know how to create a formula where it pulls through row by row, without manually changing the formula for each customer - if that makes any sense. Bare in mind that on invoice it pulls through a certain month and the statement it needs to pull through month to date.
If anyone has something similar to send me it would be awesome! Any advise would be welcome.
Thank you
I need to create a worksheet as a favour to a friend, and subsequently realised that I'm but a puppy with Excel and I need help. I've created a master sheet with each customer in a row, and by month B/f, Payment amnt, Paid amnt and Amnt Due in the columns. I then want an Invoice for the second sheet and a statement for the third sheet. I don't want to create an Invoice and Statement for each customer, so need to find a way to draw the info per customer row through to Invoice and statement, but don't know how to create a formula where it pulls through row by row, without manually changing the formula for each customer - if that makes any sense. Bare in mind that on invoice it pulls through a certain month and the statement it needs to pull through month to date.
If anyone has something similar to send me it would be awesome! Any advise would be welcome.
Thank you
