LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 152
Default Copy Validation to next row

I have a spreadsheet with data validation drop-downs; the spreadsheet may
have 2 names or may have 200 names.

Need some help with code:

Where A1 = Name; B1 has validation dropdown

B2: If B1 < "" (if there is a name) then copy A1 validation dropdown to B2

Thanks -- Suzanne
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy formatting in validation cells? iamkrisc Excel Worksheet Functions 0 June 21st 07 05:43 PM
Paste validation, Copy, Paste Special Validation Scott Excel Programming 0 December 19th 06 09:54 PM
data validation and copy/paste....... MPR Excel Programming 3 July 27th 06 03:02 PM
How to copy Validation? Joe HM Excel Programming 6 May 1st 05 02:38 PM
Excel2000: How to copy data validation using VBA Arvi Laanemets Excel Programming 1 July 13th 04 12:32 PM


All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"