Excel VBA
- or -
Post a project like this3366
$$
- Posted:
- Proposals: 12
- Remote
- #664805
- Completed
VBA, Excel,Access,SQL Development,Intrgration & Automation,Database Desigh & Development,Reporting Services
Melbourne
849746351470443720473174573552601443621560698473749846810727865154867802
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Hi freelancers! I am looking for help with some VBA code. I receive book/publication summaries in Excel with all the information on Sheet 1, Col A and it is really hard to read. I'd like to just pull out the important text that appears in certain sections in a bold cell and have it appear with the text separated by commas in a specific cell on Sheet 2. There are three different sections I am looking for, but the VBA code should be exactly the same, just looking for a different section title, so I really just need the code written once. The section titles (and only the section titles) are always in font size 16 so I know the next instance of font size 16 ends a section.
So, the code needs to be able to locate a word, bold cells, and the next instance where the font size is 16.
Again, I want to look for a particular word in Sheet 1, Col A and then from that point copy the text in all bold cells, separated by a comma, until the next instance in Col A where the font size is 16.
If the word I was looking for was Titles, in my cell on Sheet 2 I would see:
The Dog, The Cabin
A
1 12/13/2014
2 Publication A
3 Publish Group R
4 Titles
5 The Dog (IN BOLD)
6 A chapter about a dog
7 and his adventures.
8 The Cabin (IN BOLD)
9 A story about a cabin
10 in the woods that
11 might be haunted.
12 by Paul Smith
13 Lessons (font size 16)
14 Taking care of animals
15 A lesson on the care
16 of animals.
Please ask any questions before sending a proposal so I can make sure we are on the same page before we get started. I hope this will only take the right person about 30 min to accomplish.
Thank you!
So, the code needs to be able to locate a word, bold cells, and the next instance where the font size is 16.
Again, I want to look for a particular word in Sheet 1, Col A and then from that point copy the text in all bold cells, separated by a comma, until the next instance in Col A where the font size is 16.
If the word I was looking for was Titles, in my cell on Sheet 2 I would see:
The Dog, The Cabin
A
1 12/13/2014
2 Publication A
3 Publish Group R
4 Titles
5 The Dog (IN BOLD)
6 A chapter about a dog
7 and his adventures.
8 The Cabin (IN BOLD)
9 A story about a cabin
10 in the woods that
11 might be haunted.
12 by Paul Smith
13 Lessons (font size 16)
14 Taking care of animals
15 A lesson on the care
16 of animals.
Please ask any questions before sending a proposal so I can make sure we are on the same page before we get started. I hope this will only take the right person about 30 min to accomplish.
Thank you!
Noah B.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
10 Feb 2015
United States
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