Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 26th 09, 12:21 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 27
Default referencing another sheet and using autofill

the formatting seems to have gone awry but I hope you can still figure out
what I mean....


  #2   Report Post  
Old May 28th 09, 07:50 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 31
Default referencing another sheet and using autofill

Hi Merlin,

Autofill is used to fill a series of dates, numbers etc where there is a
logical progression of the series. You can do autofill from one sheet to
another using formulas. Here is sample example;

Suppse you have two sheets called File1.xls and File2.xls, and you want some
contents from File1 to copy on File2 using Autofill. You need to put the
formula inside the cell which will refer to the cell in another worksheet. By
entering below steps you can do it..
=File2!A1 (here you need to specify the file name with the cell which you
want to refer)

You can also drag this formula to the cells that you want to copy to and
relative referencing will change the formula accordingly.

Sanjay




"merlin" wrote:

the formatting seems to have gone awry but I hope you can still figure out
what I mean....




Reply
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
Auto Copy/autofill Text from sheet to sheet if meets criteria Joyce Excel Discussion (Misc queries) 0 November 21st 08 12:05 AM
Autofill a row from sheet 1 to a column on sheet 2 Janet Excel Discussion (Misc queries) 1 November 6th 08 08:57 PM
AutoFill with sheet reference help TimeCloud Excel Worksheet Functions 3 May 17th 08 05:26 PM
copy formula referencing sheet name to another sheet Tat Excel Worksheet Functions 1 June 26th 05 03:00 AM
referencing a sheet named in a cell then using data from that sheet gbeard Excel Worksheet Functions 4 April 15th 05 08:42 AM


All times are GMT +1. The time now is 11:42 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017