D&C GLug - Home Page

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

Re: [LUG] Excel Spreadsheet formula

 

Yes, that is the issue with that code, it does the desired effect (excluding the typo) but it doesn't repeat beyond one cell.
I want to pull cells from each row on one workbook and drop them into another workbook to form a list.
Could you show me your macro please?

On 16 Apr 2015 3:48 pm, "Martin Gautier" <martin.gautier@xxxxxxxxxxxxx> wrote:


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

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