As the Title Says I'm looking for VB solution to Copy A Cell to a Column X times Based On Cell Value
I have scanned though the Search Function on the forum but nothing that answers my question or no code that jumps out at me
I Have no VB coding Experience what so ever but have learnt a bit over a few days
This will be part of a bigger Project but have Attached a test sample for your viewing
Test.xlsm
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Here is another way of doing it.
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Subtle difference in our approaches: if the macro is re-run, my code will append the values to any there, whereas, Alan's will paste it to cell G1 down. Either may be what you want, so neither is right or wrong based on what you have stated the requirement to be.
Regards, TMS
You guys Are Awesome Both coding's worked a treat credit to you both
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks