Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to link two worksheet with different criteria
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to use a link to return all data matching a criteria | Excel Worksheet Functions | |||
Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions |