Same thing in 2 different worksheets

**gtmeloney** · 06-04-2009, 03:12 PM

I need to do lots of things to 2 different worksheets (an hours and a budget worksheet). Different data goes into each sheet, but the format needs to be the same. In fact, even the cell placement is the same between the sheets. Is there any way that I can easily access both sheets at the same time?

I find myself doing this alot:

Please Login or Register  to view this content.

This is a simple example, in my macro, there is alot more going on, so the repetition is getting annoying and my routines are growing very large. Any advice?

**JBeaucaire** · 06-04-2009, 03:34 PM

Repetitive actions done sequentially across

ROWS
COLUMNS
Sheets
Books
Sequentially designated Ranges

All of these (and more) benefit from a FOR / NEXT loop. Read up on them.

http://www.anthony-vba.kefra.com/vba...oop_Structures
http://exceltip.com/st/Using_Loops_i...Excel/628.html (Exercise 6)

Example:

Please Login or Register  to view this content.

This repetitively evaluates the name of every object in a sheet, if it's a "picture", it deletes it.

Another:

Please Login or Register  to view this content.

This repetitively check the value in column B for each row in a data set, deletes the rows that have error values.

Same thing in 2 different worksheets

LinkBack

Thread Tools

Rate This Thread

Display

Same thing in 2 different worksheets

Re: Same thing in 2 different worksheets

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions