LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Copying cell References from Columns to Rows

Without manually having to enter every cell reference I need ot copy multiple
cells from a column into various rows

Eg : I want to copy
Comunm M : M162:M166 (M168:M172 ...............) etc
to Row 138 : C138, D138, E138, F138, G138
Row 139 : C,D,E,F,G
Row 140 etc

Is there a quick copy and paste method for this

Or do you have to refernce every cell

Regadrs,

Michael

Regadrs,

Mick
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
prevent changes to cell references when copying and pasting MiChaos Excel Discussion (Misc queries) 2 July 3rd 07 04:21 PM
Copying Spreadsheet with Cell References Into A Different Workbook MonkeyHanger Excel Discussion (Misc queries) 1 March 28th 07 03:09 PM
How to control cell references when copying a formula? rmmshost Excel Discussion (Misc queries) 8 February 23rd 07 08:04 PM
copying sheet references that refer to a cell in the preceding she GBT Excel Worksheet Functions 1 March 24th 06 07:51 PM
Copying linked cell references. Shams Excel Worksheet Functions 0 February 3rd 05 01:53 PM


All times are GMT +1. The time now is 06:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"