[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
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/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
-- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq