copying an entire sheet dynamically

Hi all,

I would like to copy an entire sheet from a workbook W1 into another workbook W2. W1 will evolve every day. I would like W2 to update automatically every time I open it.

I know how to do it with one cell: I just create a formula in W2 referring to the cell I want to copy in W1. Easy. The problem is that I have thousands of cells and I can't do that one by one. And also, dragging the formula doesn't work with references from another workbook....
How can I copy a whole sheet please?

Oh and also, copy paste with link is not suitable because I need W2 to update even when W1 is closed.

Can somebody help me please? I'm stuck...

Thanks

Can VBA be used?

yes, but I am really a beginner at it...

maybe a program that fills the cells when I run it.
I'll see if I can but I thought maybe somebody had a solution to make the dragging of the formula possible or something.

Thank you.

You should be able to do it by dragging the formula.

When you set up your first "link" cell, change the formula to a relative instead of absolute reference.

So if it looks like ='[W1]Sheet1'!$A$1

Change it to ='[W1]Sheet1'!A1

then drag it to your other cells on W2

Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the star on the left is appreciated.