murphman25
New Member
- Joined
- May 25, 2018
- Messages
- 2
Hi all! New to the forum, and I have a question about creating a macro.
We have techs in the field collecting data about timber. Each day, we export that data to spreadsheets (images of the relevant sheets below). The way the recorders work, a certain field (Plot) has data (comments) that are output on a separate sheet in the workbook. If the comment is longer than 24 characters, the program creates a new line, preceded by a cell that contains the number of the plot it corresponds to.
What I am trying to accomplish is write a macro that will scan the ‘Plot’ column in the ‘Plot Comments’ sheet and concatenate any comments that have identical plot numbers and output the created string into a blank column (N) on the ‘Plot’ sheet on the line that corresponds to that same plot number, then delete those lines that were concatenated.
I’m trying to figure out the VBA syntax for Excel. I’m sure I could figure it out from resources on this forum and elsewhere, but I’m pinched for time to solve this problem before our QA team arrives. Any thoughts from the Mr.Excel community? Thanks in advance, folks!
Thanks, Murph
Sheet images:
Plot sheet:
https://drive.google.com/file/d/1WTqBAt3FdekUZcBb83NZlBNZ_SmkMsE5/view?usp=sharing
Plot comments sheet:
https://drive.google.com/file/d/1CK-HvOpnleYM9BQVlgs8RnxJXU8dftkU/view?usp=sharing
<style type="text/css">p { margin-bottom: 0.1in; line-height: 120%; }a:link { }</style>
We have techs in the field collecting data about timber. Each day, we export that data to spreadsheets (images of the relevant sheets below). The way the recorders work, a certain field (Plot) has data (comments) that are output on a separate sheet in the workbook. If the comment is longer than 24 characters, the program creates a new line, preceded by a cell that contains the number of the plot it corresponds to.
What I am trying to accomplish is write a macro that will scan the ‘Plot’ column in the ‘Plot Comments’ sheet and concatenate any comments that have identical plot numbers and output the created string into a blank column (N) on the ‘Plot’ sheet on the line that corresponds to that same plot number, then delete those lines that were concatenated.
I’m trying to figure out the VBA syntax for Excel. I’m sure I could figure it out from resources on this forum and elsewhere, but I’m pinched for time to solve this problem before our QA team arrives. Any thoughts from the Mr.Excel community? Thanks in advance, folks!
Thanks, Murph
Sheet images:
Plot sheet:
https://drive.google.com/file/d/1WTqBAt3FdekUZcBb83NZlBNZ_SmkMsE5/view?usp=sharing
Plot comments sheet:
https://drive.google.com/file/d/1CK-HvOpnleYM9BQVlgs8RnxJXU8dftkU/view?usp=sharing
<style type="text/css">p { margin-bottom: 0.1in; line-height: 120%; }a:link { }</style>