D&C GLug - Home Page

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

Re: [LUG] Excel Spreadsheet formula

 



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