Search results

An interesting twist on the spreadsheet. Curious to see how this works out

specifically, I would like to know if my columns have now increased on my sales record, how do i go about making the changed? narayans: https://www.dropbox.com/s/enhdekpb0altluw/Advanced%20Filter_R1.xlsm new requirement...

Hi Narayan has been extremely kind in helping me with an excel sheet (see http://chandoo.org/forums/topic/saving-whilst-using-advanced-filters?replies=1#post-89762 if interested). There is some VBA code he had written and I was wondering if anybody could help me in deciphering it. Any sort...

Also, if I may ask, would it be possible to break down your macro with a little commentary as to what each part does - just for my understanding. I have been bitten by the excel bug!

Hi Narayan Sorry for the late reply (time differences i suspect). Thank you so much! Your method is amazing! I kept at it yesterday and would like to show you what i managed to achieve ( its a really long method using vlookups and paste specials). If you have the time please check it out...

Sorry for all the posts and confusion - I am just really panicked at this point. I should have made myself clearer, One the records have been filtered into the snapshot sheet, i would like to make it so that if any CHANGES are made to the comments column, they are also saved onto the sales...

Hi Narayan Let me just say how much i appreciate this. Only the comments section with be editable - i plan to lock all other cells. Once comments are made and saved, if you repeat the action the new action should overwrite the old comments. Many thanks

Hi heres a link to my spreadsheet: https://hotfile.com/dl/201940121/91fad9a/Advanced_Filter.xlsm.html Again, thanks in advance for any help - I (stupidly) told my boss it would be done by tomorrow!!

Hi Narayan. Thank you for the reply - yes you've exactly captured what I was looking for. I will upload the sheet as soon as I have anonymised it.

Hello All, My first post - and quite an urgent one- so I would really appreciate any help from you knowledgeable people. So let me get straight into it. I have a database on one tab - ("Sales Record") which has all the names of all salesmen, the team they belong to and the product they...