Multiple Sheets with Data [Closed]

Question

Multiple Sheets with Data [Closed]

Report

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 - How-To - Excel
Auto-populate info. from master sheet to multiple sheets ✓ - Forum - Excel
Macro for merging data from multiple sheets ✓ - Forum - Excel
Split data into multiple sheets using macro ✓ - Forum - Excel
How get the data from multiple sheet to single sheet / on sheet in Excel ✓ - Forum - Windows Vista

1 reply

Ask a question

Excelguru · Answer 1 · 2009-07-17T01:32:28-0400

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

Multiple Sheets with Data [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!