Maggie Barr
Board Regular
- Joined
- Jan 28, 2014
- Messages
- 188
I desperately need help finding a way to get a VBA macro/code to get excel to give me an output table for a dataset. I am working on a PC with excel 2010. I have tried to look into pivot tables, power query, etc. as a way to do this but am not finding anything. I think the best way to do this would be through a VBA macro, but I do not have the skills to write this. Any help advice would be greatly appreciated.
I have columns A through BI. Column A is species name, B is field notes, and C through BI are field locations. I need to have an output of species found in each field location (columns C through BI). If a cell in column C is not blank (say C18), then I need an output of the cell contents to display the site name from C1 with data from A18; C18; B18 in the cell next to it.. As it continues to search for the non-blank cells it would always print C1 in the first column, and then A#; C#; B# with the number equaling the number for the non-blank cell. I hope this is making sense. What this will do is give me a list of the species and relevant information for each site. I have put a sample dataset on boxnet for you to view (https://app.box.com/s/5ovmoguhzwm5zwyst01wh8tlrn5j2942) Below is an example of what I need the output to look like.
For instance for the first two columns C & D the output would look like
<tbody>
</tbody>
Thank you in advance for your time and interest in helping me.
Best wishes,
Maggie
I have columns A through BI. Column A is species name, B is field notes, and C through BI are field locations. I need to have an output of species found in each field location (columns C through BI). If a cell in column C is not blank (say C18), then I need an output of the cell contents to display the site name from C1 with data from A18; C18; B18 in the cell next to it.. As it continues to search for the non-blank cells it would always print C1 in the first column, and then A#; C#; B# with the number equaling the number for the non-blank cell. I hope this is making sense. What this will do is give me a list of the species and relevant information for each site. I have put a sample dataset on boxnet for you to view (https://app.box.com/s/5ovmoguhzwm5zwyst01wh8tlrn5j2942) Below is an example of what I need the output to look like.
For instance for the first two columns C & D the output would look like
CI-1 | Achillea millefolium ssp. lanulosa; R |
CI-1 | Argentina egedii ssp. groenlandica; R; NEED PHOTOS |
CI-1 | Lathyrus japonicus var. maritimus; U; NEED PHOTOS |
CI-1 | Ligusticum scoticum ssp. scoticum; R; NEED PHOTOS |
CI-1 | Lysimachia maritima; R |
CI-1 | Solidago sempervirens var. sempervirens; R; NEED PHOTOS |
CI-2 | Achillea millefolium ssp. lanulosa; U |
CI-2 | Cerastium fontanum ssp. vulgare; U; NEED PHOTOS |
CI-2 | Lathyrus japonicus var. maritimus; U; NEED PHOTOS |
CI-2 | Ligusticum scoticum ssp. scoticum; U; NEED PHOTOS |
CI-2 | Moehringia lateriflora; U |
CI-2 | Picea glauca; U; NEED PHOTOS |
CI-2 | Poa pratensis ssp. pratensis; U |
CI-2 | Rumex acetosella ssp. pyrenaicus; U |
CI-2 | Solidago sempervirens var. sempervirens; R; NEED PHOTOS |
CI-2 | Taraxacum officinale; R; NEED PHOTOS |
CI-2 | Trifolium repens; U; NEED PHOTOS |
<tbody>
</tbody>
Thank you in advance for your time and interest in helping me.
Best wishes,
Maggie