[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Excel Spreadsheet formula

To: list@xxxxxxxxxxxxx
Subject: Re: [LUG] Excel Spreadsheet formula
From: Martin Gautier <martin.gautier@xxxxxxxxxxxxx>
Date: Thu, 16 Apr 2015 14:35:32 +0100
Delivered-to: dclug@xxxxxxxxxxxxxxxxxxxxx
Dkim-signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=dcglug.org.uk; s=1428397562; h=Sender:Content-Type:List-Subscribe:List-Help:List-Post:List-Unsubscribe:List-Id:Reply-To:Subject:In-Reply-To:References:To:MIME-Version:From:Date:Message-ID; bh=MjDaKO/dCOoWu8o4YJUmBI9EWjvZgu/Art4s/JcxDyU=; b=IfR87YngJODkHevjkZFShEV2PF3SloyfggaM2Xnxzw+A90E4/ECr1cPZDo/HqMIXzpwir8Zdg6ARSUShr9kw14ZTjJwD5+Gh9Tff4rYKth3e0c7ipl7o4C+AaF8pl4lbivs0JzTXR3dh8EwSf0orN5D+xLjXfcVanNrNLfMx6XU=;

On 16/04/15 14:20, Daniel Robinson wrote:

Sorry to ask this here but can anyone provide me with a formula so that I can pull data from a column as it is typed into one workbook and dump it into another workbook.

So far I can use...
=[callingsheet].xlxs]Sheet1!$B$4

This works for moving one cell but I want one formula for moving a column of data which works while adding data to calling sheet.

Any hints?

Don't you need to copy the formula down into the other cells for that to work?

Otherwise you'll need to build a macro.

That's how I'd do it - I'm not an Excel wizard by any means :S

martin

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq

Follow-up: Re: [LUG] Excel Spreadsheet formula
- From: Daniel Robinson

References:
- [LUG] Excel Spreadsheet formula
  - From: Daniel Robinson

Prev by Date: [LUG] Excel Spreadsheet formula
Next by Date: Re: [LUG] Excel Spreadsheet formula
Previous by thread: [LUG] Excel Spreadsheet formula
Next by thread: Re: [LUG] Excel Spreadsheet formula
Index(es):
- Date
- Thread