kelvs
08-14-2016, 10:11 PM
Hello,
I'm trying to copy several tables from different sheets to my main sheet. I would like it to be automatic. For example, when I add a new record on one of the tables, it should automatically be added on my main sheet as well. I was able to achieve to copy one table to my main sheet, however, I don't know how to do this with multiple sheets and tables. Here's what my code looks like:
=IFERROR(INDEX('sheet2'!F$13:F$1223,SMALL(IF('sheet2'!E$13:E$1223="IT",ROW(B$7:B$1200)-ROW(B$7)+1),ROWS(B$7:B7))),"")
I've wrote this code on my Main Sheet column B7. Whenever I add something on my sheet2, it will automatically be added to my Main Sheet as well. How can I do it so that it can work with multiple sheets and tables?
Thank you.
I'm trying to copy several tables from different sheets to my main sheet. I would like it to be automatic. For example, when I add a new record on one of the tables, it should automatically be added on my main sheet as well. I was able to achieve to copy one table to my main sheet, however, I don't know how to do this with multiple sheets and tables. Here's what my code looks like:
=IFERROR(INDEX('sheet2'!F$13:F$1223,SMALL(IF('sheet2'!E$13:E$1223="IT",ROW(B$7:B$1200)-ROW(B$7)+1),ROWS(B$7:B7))),"")
I've wrote this code on my Main Sheet column B7. Whenever I add something on my sheet2, it will automatically be added to my Main Sheet as well. How can I do it so that it can work with multiple sheets and tables?
Thank you.