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
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