Kapalı

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.

Beceriler: Excel, Visual Basic, Uygulamalar için Visual Basic, Veri İşleme, Veri Girişi

Müşteri Hakkında:
( 0 değerlendirme ) Baku, Azerbaijan

Proje NO: #33661311

Bu iş için 23 freelancer ortalamada $39 teklif veriyor

(67 Değerlendirme)
5.9
PERPETUAL0

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(132 Değerlendirme)
5.7
(44 Değerlendirme)
5.3
(77 Değerlendirme)
5.0
(22 Değerlendirme)
4.2
(2 Değerlendirme)
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 Daha Fazla

$100 USD in 7 gün içinde
(5 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$11 USD in 7 gün içinde
(0 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$35 USD in 7 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
0.0