Excel Data Entry VBA
Budget: $10 – $40 USD
I need help populating some sample data.
I have a summarised list of opportunity IDs. Each ID has an opening and closing date along with a column for number of stages.
I need sample data that expands out the opportunities into a new row for each stage.
For example Opportunity 1 has 3 stages, so there needs to be a 3 rows. The rows in between will all need a start and end date that falls between the opening and closing date of the opportunity
I have attached the data, which includes some more instructions and examples
Please let me know if you can help
Imagine someone with good VBA skills could do this
I have a summarised list of opportunity IDs. Each ID has an opening and closing date along with a column for number of stages.
I need sample data that expands out the opportunities into a new row for each stage.
For example Opportunity 1 has 3 stages, so there needs to be a 3 rows. The rows in between will all need a start and end date that falls between the opening and closing date of the opportunity
I have attached the data, which includes some more instructions and examples
Please let me know if you can help
Imagine someone with good VBA skills could do this