Hello everyone
I am trying to copy columns based on checkboxes on userform ..I have tried to do the task but I had to hard coded it to achieve my task.
Is there an easy way to do the task without this hard-coding
I would have more columns and more checkboxes ..so it will be long way
Please Login or Register to view this content.
Hope it is clear
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
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...
Thanks a lot for this great and swift help
You are wonderful Mr. Olly
loop for al controls in userform
Kind regardsPlease Login or Register to view this content.
Leo
Thanks a lot for offering help Mr. LeoTaxi
I tested your file but when I checked "Code", "Natio", "Phone", "Bad2"
I got "Name", "Salary", "Phone" copied to sheet2 !!
wrong way that i used, but you have the good solution from Olly
so i leave it like it is
Kind regards
Leo
Mr. LeoTaxi
your solution is not wrong .. it is working well after removing 1 from this line
Thanks a lot for offering helpPlease Login or Register to view this content.
Best Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks