Multiple Sheets with Data

Closed

Niki - Jul 16, 2009 at 11:18 AM
Excelguru

Posts: 261
Registration date: Saturday April 11, 2009
Status: Member
Last seen: June 21, 2011

- Jul 17, 2009 at 01:32 AM

Hi I have a spreadsheet with 8 clients listed on 8 rows. There are 9 coulmns of information. I have the following formula at the very bottom of the sheet (=SUMIF($D$5:$D$96,I113,$C$5:$C$96). I want to be able to move this formula to a separate sheet kind of like a summary sheet and have information from multiple sheets "drop in" here. I hope that makes sense.

Multiple Sheets with Data
How to auto populate data from multiple sheets to a master ✓ - Forum - Excel
How to copy data from multiple sheets to one sheet in excel - Guide
How to copy data to multiple worksheets in Excel - Guide
What should you do to enter common data, formulae, functions and formatting effects in multiple sheets? - Guide
How to fill multiple Excel sheets from master sheet - Guide

1 reply

Answer 1 / 1

Excelguru

Posts: 261
Registration date: Saturday April 11, 2009
Status: Member
Last seen: June 21, 2011

307
Jul 17, 2009 at 01:32 AM

Hello Niki

Just CUT and paste to your destination dont copy and paste

Subscribe To Our Newsletter!