Macro to filter one column and move that data into another.

[Dgp2012]

Hi All

Apologies if this has been answered before, I have searched for some time, but am finding it difficult to adapt any solutions to my needs...

I have data in column Q, and want to filter that by non-blanks then copy all entries into Column J. (Using a VLOOKUP referencing to column A, or open to suggestions).

I would also like to put this lookup/formula in the code rather than paste from a cell.

Any help would be greatly appreciated

[stanleydgromjr]

Dgp2012,

Welcome to the Excel Forum.

We could use an array in memory (very fast) that could do the work for you.

If interested, then please attach your workbook.


To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

[Dgp2012]

Thanks for your welcome, and response.

I have (hopefully) attached my sample worksheet and in the second tab simply displayed how it should look after the code has run...

[stanleydgromjr]

Dgp2012,

The Result worksheet is only showing what the changes should be made in the Sample worksheet?

What is the actual worksheet name for the Sample worksheet?

[Dgp2012]

"Price Tracker"..

[nilem]

may be

Please Login or Register  to view this content.

[Dgp2012]

Thanks for the response, but it hasn't quite worked

I think the "Q3" part is the problem but not sure what to change it to...

[nilem]

Try again. Change the values ​​in the column Q and press the green button.

[Dgp2012]

Thank you!!

The only slight problem when I transferred the data in the actual workbook it carried over the blanks. I thought this was due to formula being in there so removed the formula but it continued to carry over the blanks; is there a slight change I need to make?

Thanks again for your help!!

[nilem]

maybe so

Please Login or Register  to view this content.

[Dgp2012]

The .replace is looking for a workbook?

[nilem]

Dgp2012,
probably it would be better if you show a small example with your real data

[stanleydgromjr]

Dgp2012,

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the AdjustPrice macro.

[Dgp2012]

This has worked perfectly!

Thank you both for your time, this has helped very much

[stanleydgromjr]

Dgp2012,

Thanks for the feedback.

You are very welcome. Glad we could help.

And, come back anytime.