Accumulating Data From Sheets and preparing one summary sheet.

A

Akash

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assembling Data of 100 Sheets in one Summary Sheet 8
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Somewhat complex code to copy data from one sheet to another 9
Summary Sheet 0
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Create if partial match then copy and paste data from one cell to another 1
Copy Data from One sheet to Different Sheets 1
Copy data into sheets 13

Top