• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fill Blank Cell with value from above cell

Jeyarajm2017

New Member
HI, I have a huge data for about 5 lakh records in which i have to find the blank cells and put a formula by referring the above cell. The same has to be applied for all the blank cells. This particular vba is taking about 5-6 hours to find the blank cells and place a formula. Is it possible to make my life easier to run the file in a shorter time.
 

vletm

Excel Ninja
Jeyarajm2017
There can be many many blank cells in any worksheet!
... then it would take time!
You should upload a sample Excel-file (This particular vba is taking about 5-6 hours... ) to show Your challenge.
 

Marc L

Excel Ninja
Hi !​
Is it possible to make my life easier to run the file in a shorter time.
As we are not mind readers so forget Excel for a database software which is at least 50 times faster (sometimes more than 100x) …​
In your case your VBA code shoud use the Range.Find method, is it the case ? If not this is a direction to apply …​
 

XOR LX

Active Member
Hi,

Have you tried using Power Query? This is straightforward and fast, e.g.:

Code:
let
    Source = Excel.Workbook(File.Contents("C:\Users\Book1.xlsx"), null, true),
    Sheet1 = Source{[Name="Sheet1"]}[Data],
    #"Filled Down" = Table.FillDown(Sheet1,{"Column1"})
in
    #"Filled Down"
Regards
 
Top