H hpbaxxter Member Oct 26, 2016 #1 Hello I have 2 tables and I want to auto copy from table 1 to table 2 which, but when the table 1 was empy I dont want any thing apear in table 2 too, nothing such (0). Attachments Book2.xlsx Book2.xlsx 8.7 KB · Views: 3
Hello I have 2 tables and I want to auto copy from table 1 to table 2 which, but when the table 1 was empy I dont want any thing apear in table 2 too, nothing such (0).
H hpbaxxter Member Oct 30, 2016 #3 Chihiro said: =IF(ISBLANK(B3),"",B3) Copy down. Or if text only... =B3&"" Click to expand... Thanks Ill try it
Chihiro said: =IF(ISBLANK(B3),"",B3) Copy down. Or if text only... =B3&"" Click to expand... Thanks Ill try it