I have an automated report that generates a table of values that need to be iterated through and saved to a different format.
Here is the table:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">John Smith 5/26/2018 12345 IT Pro John Gault Permitting Sarasota
Winston Smith 5/30/2018 54321 Henchman Bob Licensing Oceania</code>The format that I'm looking to get that information to is the following:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">Name: John Smith
Date Starting: 5/26/2018
Employee ID#: 12345
Title: IT PRO
Supervisor: John Gault
Bus Ctr: Permitting
Location: Oceania
Name: Winston Smith
Date Starting: 5/30/2018
Employee ID#: 54321
Title: Henchman
Supervisor: Bob
Bus Ctr: Licensing
Location: Oceania</code>The amount of employees on the report will change on a given day, so I believe a For Each is in order, something to the effect of:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">For Each Cell In ActiveSheet.UsedRange.Cells</code>I'm just uncertain what to put into the For loop.
Here is the table:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">John Smith 5/26/2018 12345 IT Pro John Gault Permitting Sarasota
Winston Smith 5/30/2018 54321 Henchman Bob Licensing Oceania</code>The format that I'm looking to get that information to is the following:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">Name: John Smith
Date Starting: 5/26/2018
Employee ID#: 12345
Title: IT PRO
Supervisor: John Gault
Bus Ctr: Permitting
Location: Oceania
Name: Winston Smith
Date Starting: 5/30/2018
Employee ID#: 54321
Title: Henchman
Supervisor: Bob
Bus Ctr: Licensing
Location: Oceania</code>The amount of employees on the report will change on a given day, so I believe a For Each is in order, something to the effect of:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">For Each Cell In ActiveSheet.UsedRange.Cells</code>I'm just uncertain what to put into the For loop.