Đã Đóng

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.

Kĩ năng: Excel, Visual Basic, Visual Basic cho Ứng dụng, Xử lí dữ liệu, Nhập liệu

Về khách hàng:
( 0 nhận xét ) Baku, Azerbaijan

ID dự án: #33661311

23 freelancer chào giá trung bình$39 cho công việc này

(67 Nhận xét)
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 trong 1 ngày
(132 Nhận xét)
5.7
(44 Nhận xét)
5.3
(77 Nhận xét)
5.0
(22 Nhận xét)
4.2
(2 Nhận xét)
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 Thêm

$100 USD trong 7 ngày
(5 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 Thêm

$11 USD trong 7 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
0.0
Kabilar123

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

$11 USD trong 7 ngày
(0 Nhận xét)
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 trong 2 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 trong 2 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 Thêm

$35 USD trong 7 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
0.0