-
excel VBA data transfer from rows to multiple rows and columns
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
data.jpg
to table
efekt.jpg
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:daily 2.2.xlsm
Last edited by black_salami; 06-16-2017 at 03:52 AM.
-
Please post a Workbook, not images. Go Advanced/Manage Attachments
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
-
in O83 =IF(data!$H2=summary!O$81,data!$I2,"") Copy across and down
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
Thank You Sir
works perfect!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Reply With Quote