I have fairly large, 3000+ row spreadsheet. Is there a way to have a variable fill down, where I do not have to manually go to each row with blanks and fill down the information just above the blanks. It is a list of certifications, some people have 1 certification, so no problem their information is fine. Others have multiple certifications, so their information needs to be filled down, in order to match their different certifications. I will attach a screenshot, in the example rows 1613-1627 have been filled down correctly, and rows 1628-1649 is how the spreadsheet appears before manually filling down. I appreciate any and all help with this. Thanks.

Attached Images

Excel-TCFP-SS-6-8-17-2.PNG (96.0 KB, 16 views)

Hi
could you please post a sample sheet? Pictures are nice to look at but cannot be worked with

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Also this seems to be a well known problem
http://www.techrepublic.com/blog/mic...ells-in-excel/
There is probably some VBA on the Net

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here is a sample of the format that I receive it in. I have filled in only a few rows to illustrate the end result that I am wanting. Thanks for all of your help

Attached Files

CertifiedActive-Tester-1.xlsx (112.3 KB, 8 views)

Have you checked the proposed solution from post nr 3 ?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post