So i have been messing around with this spread sheet but i can not figure out a way to use the customer name to auto fill my cells based if there is price there or not. I have attached an example of what i am talking about below.
Sample.xlsx
So i have been messing around with this spread sheet but i can not figure out a way to use the customer name to auto fill my cells based if there is price there or not. I have attached an example of what i am talking about below.
Sample.xlsx
see the attached. I have added some helper column to implement the formula. you may hide them
Hi,
Attached is a modified workbork from your attached file. This should do what you require and I have tried to explain each bit on the file itself instead of on the post so that it should be clearer as to how things work.
If you need any futher help on what I've done let me know.
Say thanks, click *
my contribution to a solution
Thanks guys this is perfect all suggestions work thank you thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks