[ Date Index ]
[ Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
[LUG] Excel Spreadsheet formula
- To: list@xxxxxxxxxxxxx
- Subject: [LUG] Excel Spreadsheet formula
- From: Daniel Robinson <manipula@xxxxxxxxx>
- Date: Thu, 16 Apr 2015 14:20:30 +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:To:From:Message-ID:Date:MIME-Version; bh=OzbO9Wj0OIOISHBiMOnXiC/0TBupalGBrkC6VVTasXU=; b=bHFs8XDALAQJJBmvxLCIYcNc0ymR+QBQue1kewLqltEG4vvH9ssHfLzddw0VYWdbGPKNAImfVTz1/D94nClXl95YtsFmbwH82EXSiXtGwC+NjcuyNspiH97JLY/1X4I1vl5xhelDfPd/+MmtmTM+DKV7JC1yXHgFOzur5dho4Vo=;
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=QylhZHlINuyECSCAZ1Qo2HzNFM/BBv3FDII+H+4zHok=; b=Ep+azQ0AnR6ZZisSHSC/xRDa7PIxl/3SQ6BHwfoyKG+ku/CPVu3Aa3knV3366FvnOY ofAgwLlfpguZIBsVvddai7oVyYjM9b3h3XjNoT/68HpWHjBFlyQqReDTzGe4/UCTcNdM UVQCRT5jpykvQXmrEroYyAGvkF4f77zA02Ap1hVzGberhaxMllQmJ1tZgDRJ4AmWMMDP ij5QWA54RwpH5fDjI1pjKLXOuREppqkojzAgOIZJCUsJFNBepTxld1NSDf2eOgJPUg4L KnD/E8KkgdlWVdOHTr5nFe99cdesgIm7LFh+XqMRp9cuonm4cON3Cz5ecNeJ+yOANVhR XOpw==
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?
--
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq
