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.

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]ABC This is A1[/TD]
[/TR]
[TR]
[TD] This is A2 and needs to equal A1 [/TD]
[/TR]
[TR]
[TD] This is A3 and needs to equla A1[/TD]
[/TR]
[TR]
[TD]ABC This is A4
[/TD]
[/TR]
[TR]
[TD]DEF This is A5[/TD]
[/TR]
[TR]
[TD] This is A6 and needs to equal A5[/TD]
[/TR]
[TR]
[TD] This is A7 and needs to equal A5[/TD]
[/TR]
[TR]
[TD]HIJ This is A8[/TD]
[/TR]
</tbody>[/TABLE]


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?