ExcelBanter - Deleting rows causes #Ref!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Deleting rows causes #Ref! (https://www.excelbanter.com/excel-discussion-misc-queries/259309-deleting-rows-causes-ref.html)

Rick

Deleting rows causes #Ref!

Col A = Date field
Col B = Text
Col AB = reference data from col B
Col AB Row 15 = reference data from Row 14

Rows 2 to 14 contains formula - if(A2="",AB1,B2) -- Etc to row 14....

Fred Smith[_4_]

Deleting rows causes #Ref!

See your other post.

"Rick" wrote in message
...
Col A = Date field
Col B = Text
Col AB = reference data from col B
Col AB Row 15 = reference data from Row 14

Rows 2 to 14 contains formula - if(A2="",AB1,B2) -- Etc to row 14....

All times are GMT +1. The time now is 03:01 AM.