How to loop through columns

[todd18us]

I have the following code that matches the date between two worksheets and copies and pastes the data for a specific column. In the one below it copies and paste for F14. I would like to loop through the columns such as F14 then G14 then H14 etc. How can I go about doing that?

Please Login or Register  to view this content.

[Leith Ross]

Hello todd18us,

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[todd18us]

Hi,

Thank you for the revised code. However, the above code does not match the data between the two worksheets. I cannot get it to run.

Todd

[todd18us]

The code works but only copies and pastes the last column of data and puts it in column F of DCF. There are only two columns of data. So program should copy column and paste two columns and put it in column F and column G. Any ideas?

Thank you B. Johnson

[todd18us]

Seem like there is a problem with ms.Range("F" & Cel.Row) = .Cells(rng.Row, rFind.Column)

There should be a moving target for where the paste should occur. First in F then in G and so on of DCF.

[protonLeah]

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"