• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Saving whilst using advanced filters

T

tekkenking

New Member
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 have sold. the headers are:


[Team] [Salesman] [Product] [Quantity] [Comments]


What I have done is created a "Snapshot" sheet where using an advanced filter, I am able to pull through all the data for a selected team (team is selected via data validation drop down).


This works fine. The trouble i am having is - I would like to be able to amend the comments cells on my "Snapshot" sheet, and have it save on the "Sales Record" tab.


I don't have a clue where to begin and no real VBA knowledge!


Any and all help we be greatly and truly appreciated.
 
Hi ,


Since your requirement is very specific , it would be better if you could upload your workbook.


This forum does not have a provision for either uploading files or attaching files to posts.


What you can do is to use your preferred file-sharing website ( RapidShare , Hotfile , DropBox , SkyDrive , GoogleDocs , SpeedyShare ... ) to upload your file , give others permission to access and download the file , and then post that access link here , in this same topic.


As I understand it , you wish to have a macro which will transfer all the comments ( or is it all the cells and their comments ) from the Snapshot sheet back to the corresponding cells on the Sales Record sheet. Is this correct ?


Narayan
 
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.
 
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 ,


Can you say what should happen if you retrieve a set of records , make the comments , and they are transferred to the Sales Record sheet , and then you repeat this action with the same set of records a second time ? Should the new set of comments overwrite the earlier set , or should they be appended to the earlier set ?


Also , you have not confirmed whether you will make changes to the Comments column ( column F ) alone , or will you make changes in the other columns too ?


Narayan
 
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
 
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 record tab.


So the next time you select the same team and their records are displayed, the updated comments will appear on the snapshot sheet.


I hope this make sense.


Thanks again


Jeevan
 
Hi Jeevan ,


Can you check the file here ?


https://www.dropbox.com/s/enhdekpb0altluw/Advanced%20Filter_R1.xlsm


Narayan
 
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 - I would truly appreciate any feedback or thoughts you may have.


Many thanks for your help with this and for the time and effort you put it.


Jeevan


https://hotfile.com/dl/202168984/45a5085/Advanced_FilterV2.xlsm.html
 
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!
 
You must log in or register to reply here.
Back
Top