Is It Possible and so How?

[ReyRey]

I will try not to confuse anyone but here goes I am
working on Excel doing spreadsheets to keep track of
peoples pay. I am using 1 document. with multiple Sheets
in it. The first sheet is an overall sales log for a 7
day period with names, prices and other information. I
want to know if it is possible and if so how to copy say
just specific information from the first sheet to another
by just having it to recognize a Name. Say I have
information of Jan in Row 3B 6B and 17B and Jans personal
log is the 2nd sheet. I want to transfer specific
information located on 3A, 3G, 3J to the second sheet on
for example 5A,5B, & 5C. Same for row 6B on sheet1,
where i wannt to transfer 6A,6G,and17G to sheet 2
6A,6B,6C. And the same for row 17 B. But in Coloum B on
sheet1 the information is A name Jan is it posibble to
just allocate specific information on a weekly log that
has 5 different people @ different intervals and taking
thier specific information and posting it to a different
sheet?

Please help or tell if u need more information
Thanks
Rey

 

[wiseman]

I will try not to confuse anyone but here goes I am
working on Excel doing spreadsheets to keep track of
peoples pay. I am using 1 document. with multiple Sheets
in it. The first sheet is an overall sales log for a 7
day period with names, prices and other information. I
want to know if it is possible and if so how to copy say
just specific information from the first sheet to another
by just having it to recognize a Name. Say I have
information of Jan in Row 3B 6B and 17B and Jans personal
log is the 2nd sheet. I want to transfer specific
information located on 3A, 3G, 3J to the second sheet on
for example 5A,5B, & 5C. Same for row 6B on sheet1,
where i wannt to transfer 6A,6G,and17G to sheet 2
6A,6B,6C. And the same for row 17 B. But in Coloum B on
sheet1 the information is A name Jan is it posibble to
just allocate specific information on a weekly log that
has 5 different people @ different intervals and taking
thier specific information and posting it to a different
sheet?

Please help or tell if u need more information
Thanks
Rey

It sounds as though you need either a lookup or index & match see if these
help, if not do post back.
http://www.mrexcel.com/tip021.shtml

http://j-walk.com/ss/excel/usertips/tip020.htm

Barbara

 

[mudraker]

Can be done 2 ways

1st way is by formulas

eg on sheet2 cell a3 formalu would be something like
=Sheet1!B3


if a formula is not suitable for your needs then a macro will b
require

 

[CLR]

Hi ReyRey........

I suspect that you wish to be entering data on the first sheet on a regular
basis and then just switching over to an individuals sheet to see only
"their" current data............I can only see this being accomplished
through the use of sophisticated macros that would use the AutoFilter on
your main database and extract the desired (current) data and copy it over
to an Analysis sheet for one individual. You would not need a sheet for
each individual, only an Analysis sheet that would contain whatever
individual you would run the macro for........when you were finished with
that individual, the sheet would be cleared and then filled in for the next
individual. Unfortunately, the creation of such a macro is 'way beyond my
skills. If you wish to persue it, I would recommend you try "recording" the
AutoFilter sequence to a macro and then posting back with specific problems
you might have. If you just aren't interested in code, then I suspect you
"cannot get there from here"..........

HTH
Vaya con Dios,
Chuck, CABGx3