Excel Macro to move data to separate sheets

Microsoft Office excel 2007 home & stude...
July 1, 2010 at 09:35:56
Specs: Windows XP
Hi I am new to Excel macros, I need help
with the following automation:

I am trying to copy data from the main spreadsheet name "PMO Report" where we have 5 columns D-H and rows 10-114 paste it into different sheets based on the project name in column H. All projects except for the project name TM needs to be copied to the spreadsheets. There are a total of 6 different projects in column H. Project names are (FCS,FCD,FCT,FPD,MSS,TM). So basicly i want to extract whats in "PMO Report" columns D-H into seperate sheet based on the project name except for TM. Thanks in advance for your help...

See More: Excel Macro to move data to separate sheets

July 1, 2010 at 09:48:55
Hi Moe!

When posting in a help forum, please try to use a subject line that specific to the contents of your post.

If everyone used generic subject lines like "Excel Macro" or "Excel Help" (something we see a lot!) then we couldn't tell one question from another and things would get very confusing around here.

I fixed the subject in this thread, but we'd appreciate it if you could keep that in mind for future posts.


Office Forum Moderator

Report •

July 1, 2010 at 09:49:57
See this thread and let us know if it helps:


Report •

July 1, 2010 at 10:18:24
Hi DerbyDad03 thanks for considering my request. The thread above is a good start, but not exactly what I am looking for as per my request posted above. Do let me know if you can help write the code. Thanks Regards Moe

Report •
Related Solutions

Ask Question