Accumulating Data From Sheets and preparing one summary sheet.

Akash

Guest

Posts: n/a

8th May 2007

Hi

I have a Worksheet with 100 Sheets

In all the Sheets i have Two Columns

B & D
Column B Labels
Column D Text Box

In Each Sheet we have 24 Labels & 24 Text Boxes

No what i want is to develop a macro through which i can accumulate
data in one sheet named as Summary.

Which shows data as

Form No| Client Name / Company| Location | Version

1 XYZ ABC India
1.0
2 WXY DEF USA 1.2
3 ZWX GHI Canada 1.3

I want to accumulate all the data all the sheet present in the entire
worksheet.

How to do that.

Thanks

Akash

« IF Duplicate row then cell | Update number formatting automatically »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Best way to pull data from several different sheets into a summary sheet	Greg	Microsoft Excel Misc	2	12th Jan 2011 05:38 PM
Assembling Data of Many Sheets in one Summary Sheet	Akash	Microsoft Excel Programming	3	14th May 2007 10:46 AM
Assembling Data of 100 Sheets in one Summary Sheet	Akash	Microsoft Excel Programming	8	11th May 2007 07:00 AM
data entered on multiple sheets also added to summary sheet	=?Utf-8?B?TmFkaWE=?=	Microsoft Excel Programming	10	14th Oct 2005 08:24 AM
linking column data in sheets to a summary sheet	mhsacks	Microsoft Excel Misc	1	12th Sep 2003 03:00 PM