Help Processing Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is a repost. The original had slipped to page 6 without response.

Excel 2002-2003. I need to perform the following tasks programmatically.

1. Open a workbook.
2. Scan from top to bottom in this workbook, checking the contents of cells
in each row.
3. Place selected ranges of cells from this worksheet into new worksheets
within a new workbook.

In the end I will have taken the original single sheet workbook and placed
data from it into a new multi-sheet (around 70 sheets) workbook.

My questions are thus,

1. Does anyone have a code example of opening a workbook (and worksheet),
and scanning from top to bottom checking selected cell values?
2. Does anyone have a code example of how to select cells from one workbook
and place them into a sheet within another workbook?
3. Does anyone have a code example on how to name (or rename) a workbook
and worksheet?

This forum has truly been a blessing. So I thank ahead of time those who
will help this rusty old programmer (hacker) who now serves as a missionary.
God bless and thanks!

Chaplain Doug
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to reference a cell from anther workbook without opening it 0
Excel crashes and restarts when accessing newly created worksheet 2
Adding ws information to cell in new wb & saving with ws name 7
type mismatch error 7
VBA code for pasting links -- modifying RDB code for summary workbook 10
Protecting worksheet. 1
Copy cell value from one worksheet to matching worksheet in another workbook 4

Back
Top