Excel help please

[harveys]

Hi I hope some can help me automate the following process if possible please.

I have 2 spreadsheets A and B

I would like to add 101 rows down and 5 columns across, starting from cell A 21 from spreadsheet A to tab 1 of spreadsheet B
Then the next 101 rows down and 5 columns across from spreadsheet A to tab 2 of spreadsheet B
And so on until tab 15 on spreadsheet B

Would appreciate any help. thank you.

[sideways sid]

Record Macro (File, Options, Customise Ribbon, Add Developer Tab)

add 101 rows down and 5 columns across, starting from cell A 21 from spreadsheet A to tab 1 of spreadsheet B
Then the next 101 rows down and 5 columns across from spreadsheet A to tab 2 of spreadsheet B
And so on until tab 15 on spreadsheet B

Stop Recording

With Excel, there will be many many ways to achieve the same outcome.

[nyt]

I was curious to see what ChatGPT would make of your query:

https://chatgpt.com/share/68653563-1d74-8012-8979-...

[harveys]

THANK YOU BOTH! Appreciate your help.

I will see how I get on when I try this on Friday and report back.

[Doofus]

If you have Excel 365, you can use the TAKE function, and you won't need VBA.

The formula will require a little more engineering, but still.

[mattlovescars93]

If the cells never move and you just want to make it easier to read you could just use =(cell) as long as the files are saved in a shared location that will work fine? Unless you want to make it more complex or I’m missing the question.

[harveys]

Thank you to everyone s reply, really appreciate it.

sideways sid - I followed your instructions and after a few attempts it worked perfectly! Together with another macro I recorded I will save between 30 and 45 minutes.

nyt - I am going to try your method next for some other spreadsheets and playbooks I use.