Re: [LUG] Excel Spreadsheet formula

[Julian Hall <linux@xxxxxxxxxxxx>]

By 'macro' I think you mean some VBA code that detects the ENTER key OnClick event and dumps the cell content into the appropriate cell in another sheet?

On 16/04/15 16:44, Martin Gautier wrote:

On 16/04/15 15:58, Daniel Robinson wrote:

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

I don't have a macro - sorry. I think if you fiddle with the dollar signs in your formula it should sort it out. Don't the dollars force an absolute cell range? You want your formulae in each cell to look at different cells. I'd set up the formula in one cell then select the cell and drag it across the other cells you want to populate - that should copy the formulae across automatically changing the cell ranges to suit (your dollars are preventing Excel from doing that)

Martin

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