CRUTHERFORD
Board Regular
- Joined
- Jul 10, 2014
- Messages
- 107
Hi,
So i have two questions - one is really easy to answer im sure but the other may not be.
1st - I'm looking to learn more about VBA and how to use it; where is the best place to learn and understand or is it a skill learnt from experience and trial and error?
2nd - I have 33 different spreadsheets that i would like to pull the data from and put onto one. My problem is that currently it's such a manual process and i have to copy then paste the data under the right matching header for each one. I know its a long shot but is there any way i can have some VBA that will rearrange the headings from each of the 33 spreadhsheets and pull the info into my main one? My thoughts are that if i could do a long piece of VBA that will go through each individual spreadsheet one by one, and reorder the data to what it is in the main spreadsheet it could save me alot of time even though it might take ages to process?!
Please help...
Thanks
So i have two questions - one is really easy to answer im sure but the other may not be.
1st - I'm looking to learn more about VBA and how to use it; where is the best place to learn and understand or is it a skill learnt from experience and trial and error?
2nd - I have 33 different spreadsheets that i would like to pull the data from and put onto one. My problem is that currently it's such a manual process and i have to copy then paste the data under the right matching header for each one. I know its a long shot but is there any way i can have some VBA that will rearrange the headings from each of the 33 spreadhsheets and pull the info into my main one? My thoughts are that if i could do a long piece of VBA that will go through each individual spreadsheet one by one, and reorder the data to what it is in the main spreadsheet it could save me alot of time even though it might take ages to process?!
Please help...
Thanks