crazybuckeyeguy
New Member
- Joined
- Apr 15, 2017
- Messages
- 49
So in this report I am using I have created a template that is for pasting raw data. then I have a mast sheet that is sorted into columns as the table below. I am trying to write a vba that uses either vlookup like this: =VLOOKUP(B3,Calls!A:C,3,FALSE) for the aht and the column changes based on the acw. Im trying to have the data copy and paste in stead of the vlookup because I will need to keep adding onto the data. when AHT for 7.22 is full I will need the data to post in 7.29 in AHT and this will continue on forever. Any helpful ideas?
<tbody>
</tbody>
7.22 | 7.29 | ||||||
ID | Name | AHT | ACW | ADH | AHT | ACW | ADH |
Test | |||||||
<tbody>
</tbody>