Johnson Boni
New Member
- Joined
- Feb 9, 2020
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
Hi all
I have worked long on this project and got through 90 percent of data evaluation and compiling on my own. Which is my strong point. However, copying data into a new sheet is something I have never been good at because I hardly performed this task.
I need help in copying data into a template and creating new templates based on this data set. None of the codes i tried to write worked so I'm not going to try and share it here. I will describe in detail my situation as best i can.
I have multiple data sets in one workbook, lets call this data,xls, sheet 1. And I have a template in another workbook, template.xls, sheet 1. In the data file, sheet 1, there is data in A1:E10, A15:E18 also G1:L10, G15:L20, and so on. The second range in all will fluctuate. I am trying to get the template to copy into a new workbook, sheet1, with the data set (A:E) to be copied into it at C1 and the second at P1 then the template to copy to sheet 2 with data set G:L to be copied into cells C1 and P1 just like the first. But like i said the second data set will fluctuate so formatting will have to stop when the data ends.
I know this is a huge request but can anyone help? I understand its just creating a new workbook. And copying the template into a woksheet, copying data, but i cannot figure this out.
I thought i could attach an excel spreadsheet as an example but it isn't allowed. and image files are too large to attach.
Any help is appreciated.
Thank you.
I have worked long on this project and got through 90 percent of data evaluation and compiling on my own. Which is my strong point. However, copying data into a new sheet is something I have never been good at because I hardly performed this task.
I need help in copying data into a template and creating new templates based on this data set. None of the codes i tried to write worked so I'm not going to try and share it here. I will describe in detail my situation as best i can.
I have multiple data sets in one workbook, lets call this data,xls, sheet 1. And I have a template in another workbook, template.xls, sheet 1. In the data file, sheet 1, there is data in A1:E10, A15:E18 also G1:L10, G15:L20, and so on. The second range in all will fluctuate. I am trying to get the template to copy into a new workbook, sheet1, with the data set (A:E) to be copied into it at C1 and the second at P1 then the template to copy to sheet 2 with data set G:L to be copied into cells C1 and P1 just like the first. But like i said the second data set will fluctuate so formatting will have to stop when the data ends.
I know this is a huge request but can anyone help? I understand its just creating a new workbook. And copying the template into a woksheet, copying data, but i cannot figure this out.
I thought i could attach an excel spreadsheet as an example but it isn't allowed. and image files are too large to attach.
Any help is appreciated.
Thank you.