Microsoft Excel VBA code script macro
- or -
Post a project like this2055
£30(approx. $38)
- Posted:
- Proposals: 13
- Remote
- #2102820
- PRE-FUNDED
- Completed
+ 8 others have already sent a proposal.
Description
Experience Level: Expert
Hello
This is quite hard to explain I think it would be clearer if you see the attached example.
Basically I need a VBA code to pull information out of excel table and into a list.
Luckily I only need information from Columns B, F, G, H, I and J.
The list would contain everything from column B with an added number at the end, this number will depend on the information inside columns F to J (this information is marked with the number '1' ).
[ F= (no added number), G= _2 , H= _3 , I= _4 , J= _5 ]
If there is only 1 number in columns F - J the list would only have 1 line.
If there are 3 numbers in columns F - J the list would have 3 lines.
If there is 10 items in column B and 5 numbers in columns F - J there would be 50 lines (10x5)
I hope this makes sense. Thank for your help.
This is quite hard to explain I think it would be clearer if you see the attached example.
Basically I need a VBA code to pull information out of excel table and into a list.
Luckily I only need information from Columns B, F, G, H, I and J.
The list would contain everything from column B with an added number at the end, this number will depend on the information inside columns F to J (this information is marked with the number '1' ).
[ F= (no added number), G= _2 , H= _3 , I= _4 , J= _5 ]
If there is only 1 number in columns F - J the list would only have 1 line.
If there are 3 numbers in columns F - J the list would have 3 lines.
If there is 10 items in column B and 5 numbers in columns F - J there would be 50 lines (10x5)
I hope this makes sense. Thank for your help.
Projects Completed
8
Freelancers worked with
12
Projects awarded
35%
Last project
1 Mar 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies