Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merge Two Spreadsheets into 1 new sheet...
Hi,
Have never done vba/excel programming. Didn't know exactly what to search for. Been using vb6 for 7 years so vba won't be totally foreign if that is what is required. If I can use C# even better. Anyway... I have a client who has asked me to write a program for them that would take the data in two different Excel spreadsheets, apply some metrics and then save it into a new spreadsheet containing elements of both sheets. I need to be able to: 1. Open sheet 1 as read only. 2. Open sheet 3 as new sheet with write permissions. 3. Loop through every cell in sheet 1, test each value, on pass condition copy value to specific cell in sheet 3. 4. When sheet 1 is fully processed close sheet 1 and open sheet 2. 5. Perform same thing in sheet 2 as sheet 1 and then search sheet 3 and place related data into specific row. 6. Close sheet 2. 7. Save sheet 3 as new sheet that his merged from sheet 1 and 2. Now I'm not looking for someone to write the program. What I am wondering is do I use VB to do this, VBA from within Excel? What's the best approach and then for some brief samples that illustrate how to do this. My google searches all returned empty so I am hoping someone here has an idea. Thanks, Rex Winn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Two Spreadsheets | Excel Discussion (Misc queries) | |||
Merge several spreadsheets into one big spreadsheet | Excel Discussion (Misc queries) | |||
merge 2 spreadsheets info to 1 | Excel Worksheet Functions | |||
Compare/Merge 2 spreadsheets | Excel Discussion (Misc queries) | |||
merge 2 spreadsheets | Excel Discussion (Misc queries) |