Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2012, 12:50 AM
tomlam tomlam is offline how to cut and paste for the range Windows 7 64bit how to cut and paste for the range Office 2007
Advanced Beginner
how to cut and paste for the range
 
Join Date: Oct 2012
Posts: 33
tomlam is on a distinguished road
Default how to cut and paste for the range

Dear Sir/Madam,



I feel very headache for my routine job.

my job have item 1,2,3,4,5,6 in excel sheet as file attached name"original"
we put item 4,5,6 on the right side as my file attached name"final"

How to write the vba code to solve my problems. That cut and paste

Thanks a lot
Best Regards
TomLam
Attached Files
File Type: pdf original.pdf (230.8 KB, 12 views)
File Type: pdf final.pdf (117.3 KB, 11 views)
Reply With Quote
  #2  
Old 12-10-2012, 05:12 AM
davesexcel's Avatar
davesexcel davesexcel is offline how to cut and paste for the range Windows XP how to cut and paste for the range Office 2007
Novice
 
Join Date: Mar 2006
Posts: 7
davesexcel is on a distinguished road
Default

Hi Tomlam,

Is it possible to supply a sample workbook instead of a PDF?
Then supply more detail on what you are trying to do.

Thanks.
Reply With Quote
  #3  
Old 12-24-2012, 10:33 PM
tomlam tomlam is offline how to cut and paste for the range Windows 7 64bit how to cut and paste for the range Office 2007
Advanced Beginner
how to cut and paste for the range
 
Join Date: Oct 2012
Posts: 33
tomlam is on a distinguished road
Default

Hi

We just want the item 4 ,5,6 can move to anthoer column as
my attached name "final" files from the named "original" files . Sheet1 name "original" and sheet 2 name "final" automatically.

how to write the vba code ? (that is the programme run when meet item 4,5,6 then the programme can cut and paste the item4,5,6 information to another column)because number of item 1,2,3,4,5,6 will change from time to time(that is the total number of rows will change from time to time). but the item number 1,2,3,4,5,6 will not change

Thanks
Tomlam
Attached Files
File Type: xls dd.xls (22.5 KB, 7 views)
Reply With Quote
  #4  
Old 12-26-2012, 01:58 AM
macropod's Avatar
macropod macropod is offline how to cut and paste for the range Windows 7 64bit how to cut and paste for the range Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

What are the rules that determine which data belong in columns G-K?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 12-26-2012, 02:05 AM
tomlam tomlam is offline how to cut and paste for the range Windows 7 64bit how to cut and paste for the range Office 2007
Advanced Beginner
how to cut and paste for the range
 
Join Date: Oct 2012
Posts: 33
tomlam is on a distinguished road
Default

Hi Paul

Yes u are right. The item 4 , item 5, item 6 should belong to column G-k.
when there is only 1 sheet which show item 1-6, then we handle by our
hand easily. when there is over 100 sheets which show similar things. then
we need VBA code to help us.

Tks
Tom
merry christmas and happy new year
Reply With Quote
  #6  
Old 12-26-2012, 02:20 AM
macropod's Avatar
macropod macropod is offline how to cut and paste for the range Windows 7 64bit how to cut and paste for the range Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

That's all very well, but what are the rules (ie how does the code decide which data go where)?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to cut and paste for the range "Paste cells" in paste menu averagejoe Word 2 03-13-2012 05:40 PM
how to cut and paste for the range use VBA to name a range g48dd Excel Programming 7 06-20-2011 06:34 AM
how to cut and paste for the range Resizing the Name range derohanes Excel 4 05-27-2011 03:05 AM
how to cut and paste for the range Cut and paste a range of cells and preserve formatting StarWeaver Excel 1 03-02-2010 01:41 PM
Sort Range boutells Excel 1 07-15-2009 03:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:39 PM.


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