Macro to read and write data to multiple sheets

  • Thread starter Thread starter vvraj
  • Start date Start date
V

vvraj

Dear All,

I am beginning to learn & code in VBA.
Can anyone help me with this? How to write a macro to

1. read about 300,000 rows/records from multiple worksheets from the
same workbook.
2. for each record read, some processing/calculation is done based on
some fields in the record.
3. write back with the updated record with the computed fields to
another workbook with multiple worksheets.

(Assume each worksheet is to hold maximum of 60,000 records/row)

How would the code differ if I would were read from a text file,
compute and write to a workbook with multiple worksheets?

Thanks in advance
vvraj
 
vvraj,
For that number of rows, would it not be easier to switch to a database
program ?

NickHK
 

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

Need Macro... 8
Macros to extract data frommultiple workbooks to a master workbook 0
Combine multiple worksheets in one Workbook into one big worksheet 6
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
macro to insert row and type data 2
Copy worksheets to a different workbook 5
Copying multiple worksheets to another workbook 11
Macro for all Excel Workbooks to print to PDF 2

Back
Top