VBA program to catch Vlookup from other sheet

[Kamal Asharaf]

Dear Excel Experts,

I was trying to place vba code to copy data in Sheet1 to Sheet Master. Then i need header "Sales Type", "Classification", "Customer Type" at the top using

range("A1").End(xlToRight).Select
Selection.Offset(0, 1).Select

Then, i need data from sheet MPG via vlookup using do while till data value in cell B4 of input sheet.

value in cell B4 of input sheet = counta no of cells in sheet 1

For small data, its working but for large data say 30000 line items, it keeps on moving.

Request if you may help to tie up the vba codes and get it run faster.

A copy of dummy data is attached. Seeking your expertise knowledge to help me.
It is working for a small set of data but fails for a large set of data.


Am not able to upload the file as it showing the file attached is too large. So reducing the data to sample one.

VBA Code in module 1 is

Please Login or Register  to view this content.

[Kamal Asharaf]

The output is in the master worksheet.

[torachan]

You have been a member on this site long enough to know the rules - please re-read and comply.
Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Kamal Asharaf]

Yes, Sorry as i forget to place VBA Code in TAG code.....Request, if your goodself or any other excel master may extent help.

[Kamal Asharaf]

Dear All,

I am waiting for much needed help for correcting above mentioned VBA Codes. A copy of the sample excel file is also attached for ready reference.