0

I need to make this situation happened: Let's say I have three different tabs, let's call them Atab, Btab and Sum.

In Atab and Btab I have rows of information. In column K, I have a "comment column".

If the comment column in some row is not blank (it has a comment) - I want the whole row to be coppied to Sum tab.

So in the Sum tab I will see all of the rows of Atab and Btab with comments (on K column).

Is it possible? :)

Community
  • 1
  • 1
Lior Elenby Beilinson
  • 1
  • 1
  • 2
  • Seems to me an automated solution would have to use VBA to fully satisfy what you want. A quick fix would be just filter the two tables on the comment column, and manually copy and paste into the end sheet. – tea_pea May 12 '15 at 08:21
  • 1
    `AutoFilter` on that column and then copy it across. [This](http://stackoverflow.com/questions/11631363/how-to-copy-a-line-in-excel-using-a-specific-word-and-pasting-to-another-excel-s) will get you started – Siddharth Rout May 12 '15 at 09:18

1 Answers1

0

I want the whole row to be coppied to Sum tab.

I'm assuming you mean “the sum of the Atab and Btab should be placed in Sum tab” and with tab you mean a cell. Then the task is easy, use this formula:

=IF(K1<>""; SUM(A1:B1); 0)
Melebius
  • 6,183
  • 4
  • 39
  • 52
  • I don't think this is what the asker meant. He wants all rows having a comment in column K to be copied from `Sheet1` (called Atab) and `Sheet2` (called Btab) to `Sheet3` (called Sum). – Physikbuddha May 12 '15 at 09:54
  • @Physikbuddha Well, we both don't know what the asker means by *tab*. I assumed a cell but a sheet might be equally correct. Thanks for notice, I clarified my answer. – Melebius May 12 '15 at 10:02