Hi All,
I have to return value in comma seperated(or "-" sign) in sheet 1 from range D3 :E last row.
Criteria mentioned in G1 and I1.
Example :
In sheet 1 Header name 3G , and cell B3 which is 30537C1 in current case I will go to "All data" sheet column G and filter with same code :30537C1 and copy all the line references from column K(currently 4) and paste in sheet 1 cell D3 with comma seperated or "-" sign seperated.
Same thing I will repeat for 2G header which is 163C1 and again go to All data sheet and filter in column G with site code 163C1 and copy all the line references from column K and paste in sheet 1 cell E3 and all these steps I need to repeat to last row of sheet 1 which is current 126 site codes.
All these steps taking so much time for doing manually.
If you can suggest me any VBA solution for the same.
Link to sample data :-
https://onedrive.live.com/redir?resid=393CD98CEE2A349F!125
Thanks in advance for your support.
Regards,
Rajender
I have to return value in comma seperated(or "-" sign) in sheet 1 from range D3 :E last row.
Criteria mentioned in G1 and I1.
Example :
In sheet 1 Header name 3G , and cell B3 which is 30537C1 in current case I will go to "All data" sheet column G and filter with same code :30537C1 and copy all the line references from column K(currently 4) and paste in sheet 1 cell D3 with comma seperated or "-" sign seperated.
Same thing I will repeat for 2G header which is 163C1 and again go to All data sheet and filter in column G with site code 163C1 and copy all the line references from column K and paste in sheet 1 cell E3 and all these steps I need to repeat to last row of sheet 1 which is current 126 site codes.
All these steps taking so much time for doing manually.
If you can suggest me any VBA solution for the same.
Link to sample data :-
https://onedrive.live.com/redir?resid=393CD98CEE2A349F!125
Thanks in advance for your support.
Regards,
Rajender