Macro to copy row based on value into new sheet of same name

#10

frankjh19701 frankjh19701 is offline

Member

Posts: 89

Thanks Ben.

I got the code to work after I removed the DIM after the first one. I still need to figure out how to get teh macro to create a new sheet if a sheet with the name it searched for didn't exist.

After that, I would like to run a macro that would subtotal each worksheet by amount and location.

Any ideas?

Thank you again for Nathan and your assistance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro Help Needed...copy into new sheet based on account number	Have_Data_Will_Travel[_2_]	Excel Programming	3	April 29th 09 03:06 PM
Macro to copy and paste to another sheet, based on if-then-else	ABlevins	Excel Programming	0	May 19th 08 02:09 PM
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet.	bertbarndoor	Excel Programming	4	October 5th 07 04:00 PM
MACRO - copy rows based on value in column to another sheet	Michael A	Excel Discussion (Misc queries)	1	March 5th 05 02:15 AM
MACRO - copy rows based on value in column to another sheet	Mike	Excel Programming	2	March 5th 05 12:21 AM

All times are GMT +1. The time now is 03:19 AM.

Menu

About Us