Search results

Genius Sathish, thank you so much !

Not sure how this would work especially since the users have to select different suppliers for different rows. How can you then link the combo box selection to the different cells. I can do this manually no problem, but am looking for an automated solution.

I tried data validation initially but supplier list is very long and I had to scroll down to select supplier, I decided combo box was the better option as it enables auto fill.

Hi, I have a list of projects on a sheet, every row in column D has a combo box which draws supplier name from the next sheet "SuppName". Dependent on the supplier name, there is a vlookup formula which brings in the spend by supplier in column E. Since the combo box is on every row (in reality...

Thank you so much Smallman, it all works now. You've been a great help !! Thank you Hui for that post.

Hello Smallman I changed the code to include pasting data from columns A:L which worked. However how do I change it to paste data from row 11 down, not from row 2. Also this code stops when it contains data for an account number for which no worksheet has been set up. Were you able to find...

Oh, thank you so much. I tried and it worked, you are a champ!!! I am trying to understand your script but have got a few gaps in my understanding. Are you able to explain: - what the advancedfilter 2,[E1], 1 does? - what is column E used for and why isn't is clearing contents? - If my...

Could you please post a file, I'd really appreciate that as I haven't had much VBA experience. Thank you.

I have a worksheet called “Rawdata”. I also have several worksheets named after account numbers eg 3101,3121,3131 etc. Every month I need to filter the ‘Rawdata’ using account number as criteria, and then APPEND to respective account sheet (as I don’t want to paste over previous months data)...

Is there a way to sort a range of text data by specific criteria ie a word? Eg If A1:A100 contains various text data which may/may not contain the words 'tax', is it possible to sort the data in such a way that all words containing 'tax' appear at the top of the range??