software

we like to get data from diffent sheet or work by putting in data cell and
filling the rest of the columns automatically
ex; sheet 1 = test
sheet 2 = test1
sheet lt;testgt; has in cell a:25 lt;35gt; : cell b:25 lt;50gt; cell c:25 lt;70gt;
we will put in sheet lt;test1gt; cell a1- A link to sheet lt;testgt; row lt;25gt; then
cell b1 will fill lt;50gt; cell c1 will fill lt;70gt;
please explain we are new user

Hi dk,

Usually, you would use the VLOOKUP function.

Look at www.edferrero.com/DataTutor01.aspx for an explanation
of how to set up the worksheet, and how to use VLOOKUP.

Ed Ferrero
www.edferrero.com

gt; we like to get data from diffent sheet or work by putting in data cell and
gt; filling the rest of the columns automatically
gt; ex; sheet 1 = test
gt; sheet 2 = test1
gt; sheet lt;testgt; has in cell a:25 lt;35gt; : cell b:25 lt;50gt; cell c:25 lt;70gt;
gt; we will put in sheet lt;test1gt; cell a1- A link to sheet lt;testgt; row lt;25gt;
gt; then
gt; cell b1 will fill lt;50gt; cell c1 will fill lt;70gt;
gt; please explain we are new user
In sheet lt;test1gt;, cell A1 enter:
=test!A25

copy thru C1
B1 will hold =test!B25
C1 will hold =test!C25

HTH
--
AP

quot;dkquot; gt; a écrit dans le message de news:
...
gt; we like to get data from diffent sheet or work by putting in data cell and
gt; filling the rest of the columns automatically
gt; ex; sheet 1 = test
gt; sheet 2 = test1
gt; sheet lt;testgt; has in cell a:25 lt;35gt; : cell b:25 lt;50gt; cell c:25 lt;70gt;
gt; we will put in sheet lt;test1gt; cell a1- A link to sheet lt;testgt; row lt;25gt;
gt; then
gt; cell b1 will fill lt;50gt; cell c1 will fill lt;70gt;
gt; please explain we are new user
this is the hard way because we want row 35 we will have to retype all fields
and change all to 35 is there anyway vlookup to refrence to a cell ex: a:25
instead of a value

quot;Ardus Petusquot; wrote:

gt; In sheet lt;test1gt;, cell A1 enter:
gt; =test!A25
gt;
gt; copy thru C1
gt; B1 will hold =test!B25
gt; C1 will hold =test!C25
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;dkquot; gt; a écrit dans le message de news:
gt; ...
gt; gt; we like to get data from diffent sheet or work by putting in data cell and
gt; gt; filling the rest of the columns automatically
gt; gt; ex; sheet 1 = test
gt; gt; sheet 2 = test1
gt; gt; sheet lt;testgt; has in cell a:25 lt;35gt; : cell b:25 lt;50gt; cell c:25 lt;70gt;
gt; gt; we will put in sheet lt;test1gt; cell a1- A link to sheet lt;testgt; row lt;25gt;
gt; gt; then
gt; gt; cell b1 will fill lt;50gt; cell c1 will fill lt;70gt;
gt; gt; please explain we are new user
gt;
gt;
gt;

When you drag down the formula, the addresses will update automatically

--
AP

quot;dkquot; gt; a écrit dans le message de news:
...
gt; this is the hard way because we want row 35 we will have to retype all
gt; fields
gt; and change all to 35 is there anyway vlookup to refrence to a cell ex:
gt; a:25
gt; instead of a value
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt;gt; In sheet lt;test1gt;, cell A1 enter:
gt;gt; =test!A25
gt;gt;
gt;gt; copy thru C1
gt;gt; B1 will hold =test!B25
gt;gt; C1 will hold =test!C25
gt;gt;
gt;gt; HTH
gt;gt; --
gt;gt; AP
gt;gt;
gt;gt; quot;dkquot; gt; a écrit dans le message de news:
gt;gt; ...
gt;gt; gt; we like to get data from diffent sheet or work by putting in data cell
gt;gt; gt; and
gt;gt; gt; filling the rest of the columns automatically
gt;gt; gt; ex; sheet 1 = test
gt;gt; gt; sheet 2 = test1
gt;gt; gt; sheet lt;testgt; has in cell a:25 lt;35gt; : cell b:25 lt;50gt; cell c:25 lt;70gt;
gt;gt; gt; we will put in sheet lt;test1gt; cell a1- A link to sheet lt;testgt; row lt;25gt;
gt;gt; gt; then
gt;gt; gt; cell b1 will fill lt;50gt; cell c1 will fill lt;70gt;
gt;gt; gt; please explain we are new user
gt;gt;
gt;gt;
gt;gt;
Is this what you're looking for?

Type the row number to return into cell A2, and drag formula across columns:

=INDEX(Test!A:A,$A$2)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

quot;dkquot; gt; wrote in message
...
this is the hard way because we want row 35 we will have to retype all
fields
and change all to 35 is there anyway vlookup to refrence to a cell ex: a:25
instead of a value

quot;Ardus Petusquot; wrote:

gt; In sheet lt;test1gt;, cell A1 enter:
gt; =test!A25
gt;
gt; copy thru C1
gt; B1 will hold =test!B25
gt; C1 will hold =test!C25
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;dkquot; gt; a écrit dans le message de news:
gt; ...
gt; gt; we like to get data from diffent sheet or work by putting in data cell
and
gt; gt; filling the rest of the columns automatically
gt; gt; ex; sheet 1 = test
gt; gt; sheet 2 = test1
gt; gt; sheet lt;testgt; has in cell a:25 lt;35gt; : cell b:25 lt;50gt; cell c:25 lt;70gt;
gt; gt; we will put in sheet lt;test1gt; cell a1- A link to sheet lt;testgt; row lt;25gt;
gt; gt; then
gt; gt; cell b1 will fill lt;50gt; cell c1 will fill lt;70gt;
gt; gt; please explain we are new user
gt;
gt;
gt;
we are invoicing all info has to be in row a (same Cell) so we only pickup
the customers row (because we may several rows from the same customer which
maybe paid already which we don't need that in invoice) all detailed
description amp; charges roll over, but we are getting info from other sheet
please explain
quot;RagDyeRquot; wrote:

gt; Is this what you're looking for?
gt;
gt; Type the row number to return into cell A2, and drag formula across columns:
gt;
gt; =INDEX(Test!A:A,$A$2)
gt;
gt; --
gt;
gt; HTH,
gt;
gt; RD
gt; ================================================== ===
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ================================================== ===
gt;
gt; quot;dkquot; gt; wrote in message
gt; ...
gt; this is the hard way because we want row 35 we will have to retype all
gt; fields
gt; and change all to 35 is there anyway vlookup to refrence to a cell ex: a:25
gt; instead of a value
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt; gt; In sheet lt;test1gt;, cell A1 enter:
gt; gt; =test!A25
gt; gt;
gt; gt; copy thru C1
gt; gt; B1 will hold =test!B25
gt; gt; C1 will hold =test!C25
gt; gt;
gt; gt; HTH
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;dkquot; gt; a écrit dans le message de news:
gt; gt; ...
gt; gt; gt; we like to get data from diffent sheet or work by putting in data cell
gt; and
gt; gt; gt; filling the rest of the columns automatically
gt; gt; gt; ex; sheet 1 = test
gt; gt; gt; sheet 2 = test1
gt; gt; gt; sheet lt;testgt; has in cell a:25 lt;35gt; : cell b:25 lt;50gt; cell c:25 lt;70gt;
gt; gt; gt; we will put in sheet lt;test1gt; cell a1- A link to sheet lt;testgt; row lt;25gt;
gt; gt; gt; then
gt; gt; gt; cell b1 will fill lt;50gt; cell c1 will fill lt;70gt;
gt; gt; gt; please explain we are new user
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

I don't quite understand your explanation.

Enter this formula anywhere on sheet quot;test1quot;, and it will return the row
number of sheet quot;testquot; that you enter in cell A2 of sheet quot;test1quot; *starting*
at Column A of sheet quot;testquot;.
As you quot;drag-copyquot; this formula across columns, it will automatically
increment to return the specified row number (A2), of as many adjacent
columns as it's copied to.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;dkquot; gt; wrote in message
...
gt; we are invoicing all info has to be in row a (same Cell) so we only pickup
gt; the customers row (because we may several rows from the same customer
which
gt; maybe paid already which we don't need that in invoice) all detailed
gt; description amp; charges roll over, but we are getting info from other sheet
gt; please explain
gt; quot;RagDyeRquot; wrote:
gt;
gt; gt; Is this what you're looking for?
gt; gt;
gt; gt; Type the row number to return into cell A2, and drag formula across
columns:
gt; gt;
gt; gt; =INDEX(Test!A:A,$A$2)
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH,
gt; gt;
gt; gt; RD
gt; gt; ================================================== ===
gt; gt; Please keep all correspondence within the Group, so all may benefit!
gt; gt; ================================================== ===
gt; gt;
gt; gt; quot;dkquot; gt; wrote in message
gt; gt; ...
gt; gt; this is the hard way because we want row 35 we will have to retype all
gt; gt; fields
gt; gt; and change all to 35 is there anyway vlookup to refrence to a cell ex:
a:25
gt; gt; instead of a value
gt; gt;
gt; gt; quot;Ardus Petusquot; wrote:
gt; gt;
gt; gt; gt; In sheet lt;test1gt;, cell A1 enter:
gt; gt; gt; =test!A25
gt; gt; gt;
gt; gt; gt; copy thru C1
gt; gt; gt; B1 will hold =test!B25
gt; gt; gt; C1 will hold =test!C25
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt; --
gt; gt; gt; AP
gt; gt; gt;
gt; gt; gt; quot;dkquot; gt; a écrit dans le message de news:
gt; gt; gt; ...
gt; gt; gt; gt; we like to get data from diffent sheet or work by putting in data
cell
gt; gt; and
gt; gt; gt; gt; filling the rest of the columns automatically
gt; gt; gt; gt; ex; sheet 1 = test
gt; gt; gt; gt; sheet 2 = test1
gt; gt; gt; gt; sheet lt;testgt; has in cell a:25 lt;35gt; : cell b:25 lt;50gt; cell c:25 lt;70gt;
gt; gt; gt; gt; we will put in sheet lt;test1gt; cell a1- A link to sheet lt;testgt; row
lt;25gt;
gt; gt; gt; gt; then
gt; gt; gt; gt; cell b1 will fill lt;50gt; cell c1 will fill lt;70gt;
gt; gt; gt; gt; please explain we are new user
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;