macro to make a history sheet

[MetteGaga]

Hi

I want macro to tjek if colunm L has any cells with text in it..
if that is the case then tjek the number in column B, find that number in another sheet and copy that infomation to a third sheet

any ideas?

[Kaper]

Ideas? :

Loop through all cells in range.
If text found - take value from B, use it either Range.Find method or Worksheetfunction.Match to locate it in the other sheet, then copy from respective column to third one.

[MetteGaga]

my first problem is that all the macros i have found to look for text in range L loops forever and makes the file close..

[Kaper]

As for looping forever and closing - not seeing the code is not so easy to diagnose.

A good starting point could be limiting the column L to non-empty part, then loading all possibly-non empty part into an array and then loop through array elements.

As you have already posted almost 100 times - I probably do not have to suggest that: to receive something more detailed than just an idea consider attaching a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic