98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Duplicating Data in Lists
Duplicating Data in Lists
Resolved · High Priority · Version 2010
Fri 24 Jul 2015, 14:37Delegate 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:55Trainer 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:58Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create and delete bordersTo put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range. |
