cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

I need to create a summary sheet where I add the same cell from 5 previous sheets to a summarized

BobHa80
Copper Contributor

‎Dec 21 2022 07:44 AM

‎Dec 21 2022 07:44 AM

I need to create a summary sheet where I add the same cell from 5 previous sheets to a summarized

I am trying to add the same cell from five previous sheet to the same cell on a summary sheet

 

Labels:
442 Views
0 Likes
1 Reply
Reply
1 Reply
OliverScheurich

‎Dec 21 2022 07:55 AM

‎Dec 21 2022 07:55 AM

Re: I need to create a summary sheet where I add the same cell from 5 previous sheets to a summarize

@BobHa80 

=CONCATENATE(Table1!A1,Table2!A1,Table3!A1,Table4!A1,Table5!A1)

 

You can enter this formula in cell A1 of the summary sheet and then fill it across range A1:Z1000 for example.

0 Likes
Reply