Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Cutting and pasting from rows into columns and visa versa.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pank - 08 Nov 2006 12:34 GMT
I have numerous spreadsheets that only initially has data in 2 columns
(Column A and B) and each spreadsheet has numerous rows.

I currently have to do the following:-

1.    Select from rows 51 to row 100 and cut and paste into columns C and D.

2.    Select rows 101 to 150 and cut and paste into columns E and F.

3.    Select rows 151 to 200 and cut and paste into columns G and H.

4.    etc. etc. etc.

As one can see this is a fairly routine and repetitive and therefore fits
ideally for a macro.

I have tried to record a macro but as the number of initial rows in Columns
A and B differs every time, the macro is not is not running correctly.

Additionally, I also have spreadsheet that I need to do exactly the opposite
to the above (i.e. I have multiple columns and I need to cut and paste  the
values from columns C and D, E and F etc. etc. etc into the end position of
column A and B.

If anyone can help to create the perfect macros, then I would appreciate
their assistance.
Bernard Liengme - 08 Nov 2006 13:37 GMT
See David McRitchie's web site.:
http://www.geocities.com/davemcritchie/excel/snakecol.htm

best wishes
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I have numerous spreadsheets that only initially has data in 2 columns
> (Column A and B) and each spreadsheet has numerous rows.
[quoted text clipped - 26 lines]
> If anyone can help to create the perfect macros, then I would appreciate
> their assistance.
Pank - 08 Nov 2006 13:54 GMT
Bernard,

Thank you for the link, will have a look later.

Regards

Pank

> See David McRitchie's web site.:
>  http://www.geocities.com/davemcritchie/excel/snakecol.htm
[quoted text clipped - 30 lines]
> > If anyone can help to create the perfect macros, then I would appreciate
> > their assistance.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.