PDA

View Full Version : VBA Filtering



Ringhal
05-23-2013, 04:13 AM
Hi all,

In the attached workbook, I have 2 sheets with data. Both sheets have a table with an index in the first column (E). Both tables are very similar, the only difference is that certain rows (including indices) are missing. In table 2 (sheet 2) I will make a change and I want it copied back the first table (sheet 1) along the same index.

What I am doing is, filtering Table 1 and putting in sheet 2. I can't use the built in filter function as I change formatting and some other stuff using VBA that the builtin function cannot do. Now, I will make a change in table on, say, index 10, the code must copy the change back to the first table on the same row as index 10.

I tried a couple of codes using For Loops, VLOOKUP etc. to get the right code. I figure, with the FIND function, it can be done, but I don't know how to code it.