Hi,
I'm looking to use the Count xlup vba code to insert the data validation onto the next line each time the macro is run. Is this even possible? Your help would be excellent.
Kind Regards,
Quasis
Hi,
I'm looking to use the Count xlup vba code to insert the data validation onto the next line each time the macro is run. Is this even possible? Your help would be excellent.
Kind Regards,
Quasis
Last edited by Quasis; 02-20-2017 at 06:33 AM.
Yes. But only you know what your DV looks like, which column you want to put it in, and which column can be used to determine the next row.
Record a macro while you add your DV and then tweak it.
Or convert your data to a Structured Table (Insert | Table)
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
Hi TMS,
I appreciate that, and I did record a macro but it kept throwing up errors. Essentially each time I run the macro I just want data validation to go into column B and the data can be found on sheet2 A1:A3. Is there any way you could assist with this?
Kind Regards,
James
Post a sample workbook with some typical data.
Hi TMS,
I've now added the spread sheet, many thanks for your time.
Kind Regards,
James
Please Login or Register to view this content.
Hi TMS,
Many thanks, I've now marked it as solved. Your assistance was greatly appreciated, rep added.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks