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
Transfer data from one excel worksheet to another automatically - Guide
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
Allow multiple downloads chrome - Guide
Digital data transmission - Guide
How do you auto populate data from multiple sheets to a master? ✓ - Excel Forum

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!