Help with a Macro that will check if the cell is blank and pull data from sheet2

[Mel.Beaumont-Legal]

Hi,

I need help to write a macro that will first of all check if a cell is blank and, if it is blank will then pull data from another sheet within the same workbook.

The data will be different for every entry so it would somehow have to then find the corresponding ref on the second sheet and pull through the data contained in a specific column on the same row.

Any ideas???

If you need me to elaborate I can do.

Many thanks,

Melanie

[ben_hensel]

I dunno that you need a Macro to do this.

Like:
B1 = IF( ISBLANK(A1), sheet2!B1, "")

That will do the first half of the request, checking if a cell is blank and going and grabbing data from another cell if it is.

The second half sounds like it could be a lookup. Well, whether it's straight-forward and easy, or super-aggrevating, depends on what exactly is "somehow" different. Like, what's the corresponding reference?

Can you post an example spreadsheet, and explain the second half more concretely?