I have a problem. I have a file which has company names in Col A, and then data in cols B to D.
E.G. A2 Company name is Test Company, Col B to D has relevant data in it.
A3 is for the same company - but is blank - cols B to D have data in it.
The next Col A entry will be for a new company.
What I need is some code that enters the correct company name into the currently empty A cell.
There can sometimes be just one row for a company (in which case I don't have a problem; or there can be several - this changes each month.
I have attached a small excel file with 2 sheets - the first showing some data (as described above) the second sheet - showing what I need to happen.
Your advice / VBA would be fantastic (for info the rows will not exceed 5000) just incase this is useful.
John (scratching furiously at his head)