[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
Martin,
Removing the $ works a treat, thank you.
Now this moves onto my next issue.
The callingsheet workbook has multiple worksheets, now I need to modify my formula to take cell data from every worksheet and dump it as a list into the other workbook.
Is this possible?
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:
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)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:
Don't you need to copy the formula down into the other cells for that to work?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$4This 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?
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
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