Closed

Write VBA code to copy paste the data from multiple excels

I have folders for 22 years, each of these folders has internal folders dedicated to months, and in each month folder there are Excel files for daily values.

There are several sheets in each Excel file, and I need only certain values from one of the sheets.

I want the code to execute the following operations:

1. Open the first folder (for a year, for instance, 2000)

2. Then open the first folder in this parent folder (monthly folder, for instance, January)

3. open the first Excel file in the folder

4. Then copy the data from the predefined cells

5. Paste the copied data to the destination Excel file

6. Close the Excel file from which the data was copied

7. Save the destination Excel file.

Then, the second Excel file in the first folder needs to be opened, and the steps 4 - 7 to be repeated. After the data from all Excel files in the folder is copied, the code needs to open the second month folder and copy the data from Excels in this folder, and so on.

Once all data for a year is copied, the code moves to another year, until all 22 years data is copied.

Implications:

1. The data is inconsistent in some of the spreadsheets, i.e. the raws numbers can differ; therefore, it will be better to use some function as VLOOKUP to make sure that correct data is copied.

2. There are Excel spreadsheets for certain days, where new data is not written. For instance, in the Excel spreadsheet of 10 May, the test data will be for 9 May (one of the copied cells is date of the test). I would like this data not to be copied. Instead, it will be good to write the date as 10 May and leave the space as blanks in the destination spreadsheet.

I think that this is the essential information for the moment, please let me know in case any other information is needed.

Skills: Excel, Visual Basic, Visual Basic for Apps, Data Processing, Data Entry

About the Client:
( 0 reviews ) Baku, Azerbaijan

Project ID: #33661311

23 freelancers are bidding on average $39 for this job

(67 Reviews)
5.9
PERPETUAL0

Hello there i can make full system lookup in excel that can search inside all the files very easy regards ILYAS

$65 USD in 1 day
(132 Reviews)
5.7
(44 Reviews)
5.3
(77 Reviews)
5.0
(22 Reviews)
4.2
(2 Reviews)
1.7
vnegi2016

Hi. I am vikram, read the project description carefully. I can help to build a Automated Excel System that will do the job as per requirement. I am Experience and Expertise in Excel Automations/Macros Using VBA and More

$100 USD in 7 days
(5 Reviews)
1.5
Ashmitalakra6

Hii, I am Ashmita Lakra. I am experience in this world so I am very interested to do this anymore

$11 USD in 7 days
(0 Reviews)
0.0
srashtisaini190

Hello, I would like to know that I am a very hardworking and dedicated person. I'll do my work with full honesty. As I am a new freelancer in this sector, I don't have much working experience. But I have the qualities More

$11 USD in 7 days
(0 Reviews)
0.0
accountantexpert

Hi Sir/Madam I read all your requirements its a lengthy project but it will be simple but not as much as your project proposal. I am professional accountant so VLOOKUP is routine formula for me. Thanks & Regards

$25 USD in 1 day
(0 Reviews)
0.0
Kabilar123

Iam proficient in vlookup tool. I would like to work on your proposal. Kindly let me know about this.

$11 USD in 7 days
(0 Reviews)
0.0
rohitdhariya2001

I think i should apply for this job/project because i have good grip on microsoft excel, I am also comfortable creating spreadsheets. I believe that if I get a chance, I will do my best.

$11 USD in 2 days
(0 Reviews)
0.0
alieffebrina16

I experience full performance in terms of data entry and now I'm free I'm sure I can finish your job well and on time

$11 USD in 7 days
(0 Reviews)
0.0
kallemjamimma143

I am a good data entry operator and I have already worked as part time worker with one year experience.

$11 USD in 7 days
(0 Reviews)
0.0
Shaikabrar26262

It can be hard to stand out from the crowd, but follow these tips to write an attention-grabbing bid

$20 USD in 2 days
(0 Reviews)
0.0
pranavgunjal72

This is my first data entry work. I will not make you to fill unhappy with my work. I will try to give my best to your work. Thank you.

$10 USD in 7 days
(0 Reviews)
0.0
hiravinder

I already did this kind of work for previous company. Automated 21 sheet reporting which used to take 3-4 hour for preparing the report.

$100 USD in 7 days
(0 Reviews)
0.0
ashishgupta5833

I have 10 + years of experience in handing data and provide VBA solution to manipulate the data to reach the desired output. My experience in creating I can provide you the solution of the mentioned problem you are fac More

$35 USD in 7 days
(0 Reviews)
0.0
carolinecheptoo6

I have the required skills to do this task. And I believe my bud is reasonable and also ready to deliver on time.

$11 USD in 7 days
(0 Reviews)
0.0
dawooddilawe080

I think i should apply for this job/project because i have good grip on microsoft excel, I am also comfortable creating spreadsheets. I believe that if I get a chance, I will do my best.

$11 USD in 7 days
(0 Reviews)
0.0