Duplicating Data in Lists

Resolved · High Priority · Version 2010

Fri 24 Jul 2015, 14:37 Delegate Sean said...

Sean has attended:
No courses

Duplicating Data in Lists

22/07/2015 13:20 PODZ-NE BUY 2 97.065
22/07/2015 13:22 PODZ-NE SELL 1 97.07
22/07/2015 13:22 PODZ-NE SELL 1 97.07
22/07/2015 14:21 PODZ-NE BUY 2 97.065
22/07/2015 14:26 PODZ-NE BUY 5 97.99

above is a snapshot of a list i need to use, where the buy or sell quantity is more than 1 i need a list that replicates the line to as many times as the quantity is but listed as 1. for example:

22/07/2015 13:20 PODZ-NE BUY 1 97.065
22/07/2015 13:20 PODZ-NE BUY 1 97.065
22/07/2015 13:22 PODZ-NE SELL 1 97.07
22/07/2015 13:22 PODZ-NE SELL 1 97.07
22/07/2015 14:21 PODZ-NE BUY 1 97.065
22/07/2015 14:21 PODZ-NE BUY 1 97.065
22/07/2015 14:26 PODZ-NE BUY 1 97.99
22/07/2015 14:26 PODZ-NE BUY 1 97.99
22/07/2015 14:26 PODZ-NE BUY 1 97.99
22/07/2015 14:26 PODZ-NE BUY 1 97.99
22/07/2015 14:26 PODZ-NE BUY 1 97.99

i have manually done this but it is only a snapshot of the list where there would 1000's to do. wondering if anyone would know any shortcuts?

thanks

Fri 24 Jul 2015, 14:55 Trainer Jens said...

RE: Duplicating Data in Lists

Hi Sean,

Thank you for the forum question.

No there is no shortcuts which can do what you want. The only way of doing something like this is writing VBA codes. I do not know your experience but the right code could do what you want in one second for 1000's of records.

We offer some very interesting VBA courses which can give you the VBA knowledge you will need if you do not already have the skills.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 17 Nov 2015, 13:58 Trainer Richard said...

RE: Duplicating Data in Lists

Afternoon All,

Im trying to write some VBA code that will loop through a list and delete the entire row if the cell is below 25,000. I have tried various ways without any great affect hopefully you could help?

Regards

Sean

Fri 31 Jul 2015: Automatically marked as resolved.

Training courses