I cannot provide a viable solution. Appears to be over my skill level. I think it involves a worksheet change event, but I can't get it to work.
http://www.excelforum.com/excel-prog...ate-value.html
I cannot provide a viable solution. Appears to be over my skill level. I think it involves a worksheet change event, but I can't get it to work.
http://www.excelforum.com/excel-prog...ate-value.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
You can see from my comments at the end of Post #9 in this thread:
http://www.excelforum.com/excel-form...-solution.html
that there is something strange with the cells that appear to be empty in the file that the OP provided in Post #3.
I eventually solved the problem, but I was wondering if anyone can shed any light on the behaviour of the empty cells for the first material.
Pete
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 2 users browsing this thread. (0 members and 2 guests)
Bookmarks