B
Bernard Liengme
Please use the white space (here) to asks the question and give more detail
Happy New Year
Happy New Year
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ruchi
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
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
M
Max
Perhaps INDEX/MATCH might provide a way out for you
There's a simple example here:
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
There's a simple example here:
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
R
Ruchi
Happy new year
Thanks but i had already tried these functions that are not working on my data
Thanks but i had already tried these functions that are not working on my data
M
Max
Sorry to hear that. I'm out of ideas.
Perhaps someone else might step in
Perhaps someone else might step in
R
Ruchi
please some one help me... it is quite urgent to me
M
Max
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
Use either of these free filehosts:
http://www.freefilehosting.net/
http://cjoint.com/index.php
M
Max
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!
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!
R
Ruchi
sorry Max actually i was busy in house matter . today i will send it
R
Ruchi
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
i am not able to upload my data
R
Ruchi
link is http://www.freefilehosting.net/download/3a32e check out
M
Max
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
with the index/match implemented:
http://www.freefilehosting.net/download/3a36b
Think you'd need a programming solution to handle inventory though