Super Hard Question!

  • Thread starter Thread starter gjfeng
  • Start date Start date
G

gjfeng

linked from: http://www.mrexcel.com/forum/showthread.php?t=320701

I was thinking 1 full day yesterday about this....I still couldn't
think a way out of this. I need to convert database sheet to Navision
template as shown below(please refer to the link above for the
spreadsheet.
The Navision template is sorted by date. When that date is selected,
Only the product and customer to that date is extracted....I just
couldn't think of any possbilities on how this could be done. This is
beyond Excel abilities, right?

link: http://www.geocities.com/gjfeng/protoV2.xls
 
Hi GJ,

First up I don't think anyone will download your link when the
file asks you to enable macros.

Sounds like what you are looking for is VLOOkUP and data
validation. Take a look here at Debra Dalgleish's site
http://www.contextures.com/tiptech.html

Scroll down to Data Validation - Dependent lists as well as a few
other links there.

HTH
Martin
 
validation list - dependent lists wouldn't solve this issue...

anyway you can always download the file and scan for virus. I wouldn't
want to use macro to harm people, since I'm desperate for a solution.
 
It appears that you could benefit from professional help. With a combination
of sorting>filtering>and a macro, excel can be taught to do many things to
include your desires.
 
Back
Top