Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-27-2014, 03:00 AM
funkyfido funkyfido is offline Macro help Windows XP Macro help Office 2007
Novice
Macro help
 
Join Date: Jun 2013
Posts: 24
funkyfido is on a distinguished road
Default Macro help

I have a large spreadsheet where all the data comes out in the one go. I want to do the following:-

Find CY and copy all the data (columns A-L) up to DL but not including DL and put it on a new sheet named CY
Find DL and copy all the data up to EU but not including EU and put it on a new sheet named CY
Find EU and copy remaing data into a new sheet named EU.

How would I do this? I am fairly new to macros so any help would be appreciated. I have attached a test copy of my data.
Attached Files
File Type: xlsx Test file.xlsx (430.7 KB, 11 views)
Reply With Quote
 

Tags
macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
custom icon, undo/redo for macro, permanent macro Rapier Excel 0 08-05-2013 06:30 AM
How do I assign a macro to a button when the macro is in my personal workbook? foolios Excel Programming 2 07-27-2011 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft