• 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.

Search and Update

Can you send me the column mapping of the dashboard with the search file
i.e. which columns from the Dashboard file should reflect in the destination file columns?

Regards,
Don
 
inddon said:
Can you send me the column mapping of the dashboard with the search file
i.e. which columns from the Dashboard file should reflect in the destination file columns?

Regards,
Don
Click to expand...

Have a look at it (attached file). Hope this is what you are looking for

Regards,
Don
 

Attachments

  • File 2 Don Draft1.xlsm
    34.5 KB · Views: 6
one doubt, can I search without convert the worksheet into table,
here we used 'O_MasterTB = MasterWS.ListObjects("MyTable")
 
Glad it is working for you!

Your Dashboard file has a table. The below code just refers to that table "MyTableNew". There is no conversion done.


Code: 
O_MasterTB = MasterWS.ListObjects("MyTableNew")

Also, I have removed the unnecessary code of ADO SELECT
 
is it possible to search from normal worksheet data without convert into table
without using
Code: 
O_MasterTB = MasterWS.ListObjects("MyTableNew")
 
You must log in or register to reply here.
Back
Top