HalfBaked01
New Member
- Joined
- Jan 17, 2018
- Messages
- 4
Hello,
New here, I attempted to search for a solution but could not find what I was looking for so thank you in advance.
I am trying to write VBA code to copy rows of data based on a value into a new sheet and save this sheet with a cell value name
<tbody>
</tbody>
Above is a sample of what the data looks like, I am attempting to copy based on separate payments that were received.
A few notes;
Company Header will have duplicates
Total Amount could be duplicate but highly unlikely
Invoice Number could be blank
Invoice amount could be blank
Below is how I would like it to look saved as a separate file based on Company name;
<tbody>
</tbody>
Again, thank you for your help
-Novice VBA User
New here, I attempted to search for a solution but could not find what I was looking for so thank you in advance.
I am trying to write VBA code to copy rows of data based on a value into a new sheet and save this sheet with a cell value name
Date Header | Company Header | Total Amount Header | Invoice Number | Invoice Amount |
1/17/18 | ABC Company | $1,000 | 12345 | $100 |
12346 | $900 | |||
1/17/18 | BCD Company | $500 | ||
1/17/18 | CDE Company | $450 | ABC123 | -1745 |
<tbody>
</tbody>
Above is a sample of what the data looks like, I am attempting to copy based on separate payments that were received.
A few notes;
Company Header will have duplicates
Total Amount could be duplicate but highly unlikely
Invoice Number could be blank
Invoice amount could be blank
Below is how I would like it to look saved as a separate file based on Company name;
Date Header | Company Header | Total Amount Header | Invoice Number | Invoice Amount |
1/17/18 | ABC Company | $1,000 | 12345 | $100 |
12346 | $900 |
<tbody>
</tbody>
Again, thank you for your help
-Novice VBA User