Hi all,
I'm trying to create a macro so that when you push the button on sheet "Meter List" it will copy any row from sheet "Index" that has Yes selected in the dropdown in Column U, and put that information starting in the first blank row which is Row A14 on the same sheet as the button
I have an example workbook with two dropdowns in a row. The code I tried so far is
Please Login or Register to view this content.
First code wasn't even close, trying this now, the code executes but nothing is copied, seems im missing the part to focus on sheet "Index"
Please Login or Register to view this content.
Were you able to get a solution to this?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
hi soldevi53, option using Autofilter method, please check attachment, press "Populate Meter List" button
Please Login or Register to view this content.
Last edited by watersev; 02-17-2012 at 05:43 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks