PDA

View Full Version : Filtering out a specific range and pasting it a row below



Markiepoop
01-17-2017, 11:39 PM
Hi all,

I am trying to automate a monthly process at my workplace, and am faced with a road block at this point of time.

Let me try to explain the issue as succinctly as I can.

Every month, I will receive two excel worksheets, "Company One" and "Company Two". They come in differing formats. My job is to standardize both sheets and combine them together.

Workers in both companies are under two schemes, "DX" or "QQ". I have managed to figure how to standardize the both sheets, but am unable to write a code that filters the DX scheme from the QQ, and cut and paste it one row below the personnel under QQ scheme.

On the worksheet in the file is the ideal outcome of what I desire.

If anyone could lend their expertise, I would greatly appreciate.

Thanks! And Have a nice day ahead.

18063

Kenneth Hobs
01-18-2017, 07:22 AM
Welcome to the forum!

I looks like Column A in the first two sheets means nothing to sheet three? It also looks like duplicates in columns 2-4 in each of the two sheets are not repeated in sheet three?

Markiepoop
01-18-2017, 04:43 PM
Thanks.

Yup, column A solely denotes the serial number, so it holds no actual significance.

However, what do you mean by duplicates in columns 2-4 not repeating in sheet three?

Kenneth Hobs
01-18-2017, 05:22 PM
Sheet1 row 5 = Sheet2 row 4 = Sheet 3 row 27 only, rather than two rows of the same value...