ColletteLuffman
New Member
- Joined
- Jul 14, 2019
- Messages
- 9
HI
This is my first post so please be gentle. I am not great with VB so might need some hand holding
I have a spreadsheet will lots of columns (about 30) and 2000 rows
I would like to use this spreadsheet to populate multiple other sheets but keep the data in the master sheet.
Each time we add a new row to the master the row of data needs to be moved to 1 or multiple sheets depending on criteria.
List of fields below
<tbody>
</tbody>
eg The new row is added.
If column O is Active and Column H is New then put in Active New Sheet
else If column O is Active and Column H is Old then put in Active Old Sheet
else If column O is Complete then put in Complete Sheet
Hope this makes sense
Thanks
Collette
This is my first post so please be gentle. I am not great with VB so might need some hand holding
I have a spreadsheet will lots of columns (about 30) and 2000 rows
I would like to use this spreadsheet to populate multiple other sheets but keep the data in the master sheet.
Each time we add a new row to the master the row of data needs to be moved to 1 or multiple sheets depending on criteria.
List of fields below
Date | Contract No |
<tbody> </tbody> | Customer Name | Post Code | Site Postcode | Contract (Old or New) | Date of last Service visit to site | Start Date | Renewal Date | End Date | Reference | Payment Type | Contract Status | Band | Frequency of Service | Frequency of Service2 | Preferred Service Month (1) | Preferred Service Month (2) | Preferred Service Month (3) | Preferred Service Month (4) | No. Of Pieces Of Equipment | Payment Option | Value Per Visit | Annual Service Value | Contract Type | Last Service Date | Last Service Invoice Date | Last Service Invoice amount | Next Action |
<tbody>
</tbody>
eg The new row is added.
If column O is Active and Column H is New then put in Active New Sheet
else If column O is Active and Column H is Old then put in Active Old Sheet
else If column O is Complete then put in Complete Sheet
Hope this makes sense
Thanks
Collette