how to link two worksheet with different criteria
 

how to link two worksheet with different criteria
 

Please use the white space (here) to asks the question and give more detail
Happy New Year
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Ruchi" wrote in message
...

how to link two worksheet with different criteria
 

Happy new year

Actually i have all data in a workbook. one worksheet contains all day to
day data. and another sheet is its storage. how can i link the date cells of
both sheet so only once i have enter the data. simultaneously date is also
checked with the product column.each product is having seperate space in
storage sheet.
pls suggest something

"Bernard Liengme" wrote:

Please use the white space (here) to asks the question and give more detail
Happy New Year
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Ruchi" wrote in message
...

how to link two worksheet with different criteria
 

Perhaps INDEX/MATCH might provide a way out for you

There's a simple example he
http://www.freefilehosting.net/download/39kh9
Index n Match Example.xls

You should also check out Debra Dalgleish's
nice coverage on INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH
There's some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ruchi" wrote:
Actually i have all data in a workbook. one worksheet contains all day to
day data. and another sheet is its storage. how can i link the date cells of
both sheet so only once i have enter the data. simultaneously date is also
checked with the product column.each product is having seperate space in
storage sheet.
pls suggest something

how to link two worksheet with different criteria
 

Happy new year

Thanks but i had already tried these functions that are not working on my data

"Max" wrote:

Perhaps INDEX/MATCH might provide a way out for you

There's a simple example he
http://www.freefilehosting.net/download/39kh9
Index n Match Example.xls

You should also check out Debra Dalgleish's
nice coverage on INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH
There's some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ruchi" wrote:
Actually i have all data in a workbook. one worksheet contains all day to
day data. and another sheet is its storage. how can i link the date cells of
both sheet so only once i have enter the data. simultaneously date is also
checked with the product column.each product is having seperate space in
storage sheet.
pls suggest something

how to link two worksheet with different criteria
 

Sorry to hear that. I'm out of ideas.
Perhaps someone else might step in
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ruchi" wrote
Thanks but i had already tried these functions
that are not working on my data

how to link two worksheet with different criteria
 

please some one help me... it is quite urgent to me


"Max" wrote:

Sorry to hear that. I'm out of ideas.
Perhaps someone else might step in
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ruchi" wrote
Thanks but i had already tried these functions
that are not working on my data

how to link two worksheet with different criteria
 

Upload a sample of your file, post the link to it here

Use either of these free filehosts:
http://www.freefilehosting.net/
http://cjoint.com/index.php

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ruchi" wrote in message
...
please some one help me... it is quite urgent to me

how to link two worksheet with different criteria
 

well, I guess you have your reasons to decline the earlier offer given

You could try putting in a new posting, but do include more detail in your
posting, eg: describe sheet set-ups, show some sample data and the desired
results etc. The more specifics you give, the more likely that a possible
response(s) could be provided, good luck!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

how to link two worksheet with different criteria
 

sorry Max actually i was busy in house matter . today i will send it


"Max" wrote:

well, I guess you have your reasons to decline the earlier offer given

You could try putting in a new posting, but do include more detail in your
posting, eg: describe sheet set-ups, show some sample data and the desired
results etc. The more specifics you give, the more likely that a possible
response(s) could be provided, good luck!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

how to link two worksheet with different criteria
 

dont mind but can u give me ur id where i can send file, u can trust on me .
i am not able to upload my data

"Max" wrote:

well, I guess you have your reasons to decline the earlier offer given

You could try putting in a new posting, but do include more detail in your
posting, eg: describe sheet set-ups, show some sample data and the desired
results etc. The more specifics you give, the more likely that a possible
response(s) could be provided, good luck!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

how to link two worksheet with different criteria
 

link is http://www.freefilehosting.net/download/3a32e check out


"Ruchi" wrote:

dont mind but can u give me ur id where i can send file, u can trust on me .
i am not able to upload my data

"Max" wrote:

well, I guess you have your reasons to decline the earlier offer given

You could try putting in a new posting, but do include more detail in your
posting, eg: describe sheet set-ups, show some sample data and the desired
results etc. The more specifics you give, the more likely that a possible
response(s) could be provided, good luck!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

how to link two worksheet with different criteria
 

Here's your sample (it was quite bare - you didn't provide much detail),
with the index/match implemented:
http://www.freefilehosting.net/download/3a36b

Think you'd need a programming solution to handle inventory though
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---