Only filling in blanks
Hi All,
In short, I'm trying to pull in values from Column B to Column A only if Cells in Column A are blank. If cells in Column A are populated, they should not be changed. Also, Column A values should be in "general" format.
Does any one know how this would be expressed in VBA code?
Thanks
2ndLunch
You can filter to accomplish that, or use VBA to apply said filter.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I've been filtering and tried recording a macro to filter but the problem arises when the data changes from day to day. For example, the filter macro will only look at certain rows. When those rows change the next day, the recorded macro will only look at those recorded rows. This is one step and longer process so I was hoping there was a VBA code solution.Originally Posted by mikeTRON
Thx
2ndLunch
It sounds as if your macro works but you have another issue, how to make it work for a dataset with a different row count each time.
Luckily this is a very common problem and easy to solve.
http://www.thespreadsheetguru.com/bl...lumn-using-vba
Have you tried the Macro I provided you? It worked when I tested on my PC based upon your requirements.
Thx Alan, this worked perfectly!
Awesome, thank you. Very useful
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks