Hi and welcome to JA!. In order to better assist you could you please upload your workbook to www.wikisend.com. After upload please provide me with the File ID number or Download Link. Please replace any “Private” data with dummy values to protect your privacy. I will take a look and suggest the best way to accomplish your wants :)
unable to upload on the given site any other option available?
check either of them ......it just leads to a blank screen thus do not know for sure if the same has been attached or not if u can send me an email or something i can email it to u too.
Thats them :)
cool ,in sheet 3 i have prepared how i want my data to look like, going offline now working tomorrow...do u need anything else?
You sent two..are they the same?
yup just pick up any 1
I will let you know if I have any questions. :)
did not know if it has attached properly or not thus uploaded it twice
Good night :)
or shall i say g morn to u
Its afternoon here
k take care
I added a Sheet called Data to your Workbook. I need you to finish filling it out with all related data before I can finish this. In order for the Category's to be seamless it must be done this way. :)
i will try to update as much as possible but i would need to keep adding the items regularly, also each category has its own brand would you be labeling them accordingly in the future? for eg bevrages option Cola brands to choose Pepsi,coca cola,7 up.
also just wanted to know the other columns like stores and weights would be added later right?
Its a challenge to make it adaptable but it can be done :). I would make room for way more info then is needed. e.g 30 rows for each Category or even 40. Yes, we will incorporate Price and weight too.
Sounds good :)
I have updated it the maximum possible with enough rows and column as might be required in the future please see if it helps you i was going thru net and found conditional data validation is possible you might want to have a look at that,
Here ya go. The base work is done. Follow the instructions inside to complete. I gave examples and color coded Ranges for ease of understanding :)
I hope this is what you wanted :) Dont forget to Rate me with a Smiley face so I can get credit for helping you :)
sorry but where is the file? couldnt find any attachments...
sorry but i am new to all this am i supposed to go back to my uploaded file or something as i cant see any new link to file posted by you also tried to open the previously uploaded file but couldnt view any changes in that apologies for being such a dumwit.
Thats wierd lol it was there a minute ago.
Try this :)
Click the big Green Download button on the right.
thanks it all done i managed to get the formula to work too except i need the data validation list to cross update from the price list i.e that instead of updating it in the data sheet what if i could enter into the main sheet and the same gets updated on the data sheet