Sending data from one cell to another

Tania · External Since: Mar 09, 2006 Posts: 12

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..

Atishoo · External Since: Feb 20, 2009 Posts: 9

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..
>

Simon Lloyd · External Since: Oct 31, 2009 Posts: 1

In your form use VLOOKUP like this =VLOOKUP(A1,Sheet2!A1:C12,2,FALSE)
where the formula in this case would go in the area on your form A1
would hold the Clients name sheet2!A1:C12 is the whole range of my data
in the 3 columns, 2 is the column to give the value from and FALSE means
give an exact match.

Tania;544124 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..

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=149701