LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 17
Default assistance need with excel doc

Hi guys

I am trying to copy rows which has minor function. These 5 rows have titles
and a functions displaying items from another sheet. I tried to multiply
(copy) these rows buy dragging the mouse down the sheet, but it makes copies
with the function adding 5 instead of + 1. e.g
"=Evaluation!C5&Evaluation!AY5&Evaluation!D5", the next set would be
"=Evaluation!C10&Evaluation!AY10&Evaluation!D1 0" instead of
"=Evaluation!C6&Evaluation!AY6&Evaluation!D6". I would like to know if I
could copy these 5 rows a set adding + 1 for the formula instead of + 5?

asssistance is highly appreciated, thanx

Geno
 
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
cell color assistance for excel new user New Users to Excel 2 May 28th 09 08:09 AM
Assistance with password in Excel mj Excel Worksheet Functions 1 August 28th 06 10:08 PM
How can I get assistance on Excel Formula? art500 Excel Worksheet Functions 2 August 26th 06 06:21 PM
1-2-3 @ function to Excel Assistance CMA Excel Worksheet Functions 8 March 20th 06 11:49 PM
Turn off Assistance pane in Excel Petra Excel Discussion (Misc queries) 1 December 1st 04 02:19 AM


All times are GMT +1. The time now is 09:56 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"