How to insert a row below ActiveCell, copy row down, and add 'v1' to the existing number
Greetings all,
Well I'm six hours down without success, so I'd be extremely grateful for any help.
Excel variation macro query.PNG
What I'm trying to achieve is
Select a cell in column A, lets say '004'
Click Variation button
Excel copies the entire row and inserts it below
Excel adds v1 to the number so you end up with 004v1
Really has me stumped!
I have the drop down bit but not the adding of the v1
Please Login or Register to view this content.
Last edited by jamesywilkinson; 11-22-2013 at 10:31 AM.
Try:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thank you so much! You've managed in 6 minutes what I couldn't in 6 hours! It works, however it does drop the first two 0s, suspect converting to text would resolve that? will certainly give it a try
Thanks again Olly
J
Glad it's doing what you want. Hard to comment on the leading zeros on your number column, as I can't see how you have those cells formatted. The leading zeroes should stay if they're already formatted as text. If they're currently formatted as numbers with the format "000", then change the last line of code to;
Please Login or Register to view this content.
Thank you so much! Works a treat!!
Take the rest of the day off and have a good weekend!
J
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks