VBA Loop Table Values

[Pinaceous]

Hi All;

I have 3 Data Tables,

ie.

Range("C2:V172")
Range("C173:V372")
Range("C373:V573")


Of which I'd like to create a VBA loop in catching the values set by the unique id held in Column C to take the values in Columns G & I in the Range("C173:V372") and to delete its duplicate from the other tables.



Thanks,

Pin.

 

[hiker95]

Pinaceous,

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

To start off, and, so that we can get it right on the first try:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, flat text) try one of the following:

MrExcel HTML Maker
If you do not know how to install and how to use HTML Mr.Excel Maker
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be

Excel Jeanie
Download

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here


Or, you can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.