IF THEN copy & paste macro

yowzers posted on Wednesday, January 20, 2010 1:53 PM

I am new to macros.  In column A, I have a bunch of tiers (i.e. A, B, C, D,
etc.) and then columns B through F, I have corresponding data.  I want to
write a macro where IF column A = A, THEN copy columns B through F and then
paste them into columns B through F and paste them into columns B through F
in a new workbook (already existing).

Didn't Find The Answer You Were Looking For?

View Excel Worksheet Posts Ask A New Question

EggHeadCafe has experts online right now that may know the answer to your question. We pay them a bonus for answering as many questions as they can. So, why not help them and yourself by becoming a member (free) and ask them your question right now?

Create Account & Ask Question In Live Forum

Previous Excel Worksheet conversation.

Excel Excel Charting Excel Crashes GPFs Excel Miscellaneous Excel New Users Excel Programming Excel Setup Excel Worksheet MAC Office MAC Office Entourage MAC Office Word Word Application Errors Word Conversions Word Menus Toolbars Word Document Management Word Drawing Graphics Word International Features Word mail Word Mail Merge Fields Word New Users Word Numbering Word OLE Interop Word Page Layout Word Printing Fonts Word Setup Networking Word Spelling Grammar Word Tables Word VBA Add-Ins Word VBA Customization Word VBA Word VBA User Forms Works Windows Office Developer Automation Office COM Add-Ins Office Developer Other Office Outlook Forms Office Outlook VBA Office Developer VBA Office Miscellaneous Office Setup Office Update One Note Outlook Outlook BCM Outlook Calendaring Outlook Contacts Outlook Fax Outlook General Outlook Installation Outlook Interop Outlook MAC Outlook Printing Outlook Program Add-Ins Outlook Program Forms Outlook Program VBA Outlook 3rd Party Utility PowerPoint Project Project Developer Project Server Visio Visio Developer Visio General Word VBA Beginners Outlook Express Office Communicator Groove Word Programming Developer Outlook AddIns Office Templates Misc