Equal Formula for Multiple Blank Cells

[dmill8023]

Hello all, I want to come up with an = formula that references a second tab. For this example I'll have Tab 1 and Tab 2.

On Tab 1, starting @ A1 I want to do ='Tab 2'!A1 and copy that down. On tab 1 I need copy my = formula down, I can't lok A1 because the unique value below DEF where just like ABC I need those blank cells to be populated with DEF.

ABC This is A1

This is A2 and needs to equal A1

This is A3 and needs to equla A1

ABC This is A4

DEF This is A5

This is A6 and needs to equal A5

This is A7 and needs to equal A5

HIJ This is A8

<tbody>
</tbody>

I am having issues figuring out the way to make this work. I have tried a =if( referencing if the cell is blank take the value above...however when I have 2 consecutive blank rows the formula doesn't work...does this make sense?

Any help or insight is greatly appreciated.

Thanks!

 

[BQardi]

Something like this:

In B1:

=A1

In B2:

=IF(A2="",B1,A2)

Copy B2 down...

 

[dmill8023]

thank you for the reply - i am not looking to add a formula to a column because i'm trying to create an automated tool that my colleague doesn't have to do any additional manual work. Currently Tab 1 is pulling in data to appropriate columns from data that is pasted into Tab 2. This is being done with a simple = formula between the two tabs.

I then have a macro created to autofill based on the number of rows needed. My issue is that I may have 1 order # with 3 different commodities however my order # for those repeat rows isn't populated. Same with other important Origin, Dest information. That is why my = isn't working because there is nothing for me to tie in.

 

[BQardi]

Can you post a small example of what your data looks like and what you want it to look like?