PDA

View Full Version : excel VBA data transfer from rows to multiple rows and columns



black_salami
06-16-2017, 02:11 AM
I am trying to automate one of my reports with VBA and so far i have failed. So can someone please help me with my issue.

Thing i am trying to do is to transfer data from column I

19522

to table

19523

I would like the data from column I to be transferred into the table depending on the data from column H into cell with corresponding name as shown above.



Any help with code will be greatly appreciated.


File here:19524

mdmackillop
06-16-2017, 03:41 AM
Please post a Workbook, not images. Go Advanced/Manage Attachments

black_salami
06-16-2017, 03:53 AM
done.

mdmackillop
06-16-2017, 04:29 AM
in O83 =IF(data!$H2=summary!O$81,data!$I2,"") Copy across and down

black_salami
06-16-2017, 04:52 AM
Thank You Sir

works perfect!