Hi Tania.
How is the designated area on sheet 1 identified?
Are you just creating a new list on sheet 1 or is it something more specific?

"Tania" wrote:

Just hoping that someone may be able to help. I have read posts, and have
tried some of the suggestions that I was able to understand, but
unfortunately have just confused myself further and I need to clarify what
feature I should be trying to learn and use for this exercise. This is my
story:
I have Sheet 1 and Sheet 2 in my workbook.
On Sheet 1 is a Form that has areas that need to be filled in, it is like a
blank template.
On Sheet 2 is a List of Col A - Client Numbers Col B - Volumes / Litres Col
- C Clients Last Name (just a very simple list), the only thing that gets
changed daily is Col B - Volumes/Litres.
I typing into Sheet 2 the Volumes / Litres Column daily - then once I have
completed all Vol/Ltrs for each Client in Sheet 2, I then select individual
Rows and copy and paste this data into the Form on Sheet 1,
My big question is... When I have completed the Daily Vol/Ltrs Column on
Sheet 2 for all Clients in the List, am I able to just select or click on the
Cell:A2 26100 (Client No.) Cell:B2 2462 (Vol/Ltrs) Cell:C2 Smith (Cust Last
Name) together and this info will appear in Sheet 1 on my Template Form in
the designated area? I really would appreciate any help on this..