Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to read and write data to multiple sheets
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 ------------------------------------------------------------------------ vvraj's Profile: http://www.excelforum.com/member.php...o&userid=33100 View this thread: http://www.excelforum.com/showthread...hreadid=537977 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to read and write data to multiple sheets
vvraj,
For that number of rows, would it not be easier to switch to a database program ? NickHK "vvraj" wrote in message ... 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 ------------------------------------------------------------------------ vvraj's Profile: http://www.excelforum.com/member.php...o&userid=33100 View this thread: http://www.excelforum.com/showthread...hreadid=537977 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compiling data from multiple Excel sheets - macro? | Excel Worksheet Functions | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
How to write a macro to open a file read-only? | Excel Programming | |||
How to read a SQL Table into Excel change the data and write back into SQL | Excel Programming | |||
Read/Write data to/from text files from a spreadsheet. | Excel Programming |