Excel VBA code for updating workbook from external sheet with different date structure

I have the following situation:

I have 2 excel workbooks each contains 1 sheet, holiday trackers. I am trying to update holiday_tracker2 (workbook2) with data from holiday_tracker1 (workbook1). Tricky situation is that the date structure in holiday_tracker2 is different then in holiday_tracker1.

In holiday_tracker2 H=8h, HD=4h

In holiday_tracker1 there are values 8, 40, 24 and 4

How can I automatically update holiday_tracker2 with this values but to be assigned to the same format H,HD?

I need VBA code which will work on original files.

Skills: Excel, Excel VBA, Visual Basic for Apps

See more: excel vba code optmization, excel vba code optimis, excel vba code log websites, excel vba import data from another workbook without opening, excel macro pull data from another workbook, excel macro to copy data from one sheet to another based on criteria, how to copy data from one excel workbook to another using macro, excel vba copy data from one sheet to another based on cell value, macro to copy specific columns from one worksheet to another worksheet, excel vba get data from another workbook without opening, transfer data from one excel worksheet to another automatically, excel vba code open internet explorer, inventory excel vba code, excel vba code check add ins, excel vba code data web page, create domain class excel vba code, ftp connection excel vba code, excel vba code pull internet data, excel vba code save web page, excel vba stop updating

About the Employer:
( 1 review ) London, United Kingdom

Project ID: #18719210

Awarded to:


I have FULL CONFIDENCE in helping you with VBA code for updating holiday_tracker2 (workbook2). First of all, you can easily co-relate the values such as 28/1/2019, 4/2/2019, 11/2/2019 present in holiday_tracker1 to More

£13 GBP in 1 day
(6 Reviews)

31 freelancers are bidding on average £20 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( More

£50 GBP in 1 day
(724 Reviews)

Hello , I have checked the files, read your project description and understood your requirement. I can write VBA code for yourrequirement or I can write VLOOKUP formula in excel so you can update holiday More

£20 GBP in 1 day
(432 Reviews)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best rega More

£20 GBP in 3 days
(227 Reviews)

Greetings! Just to confirm, a value of 40 in holiday_tracker1 - does it correspond to 5H in holiday_tracker2? If it is OK with you, I can change the format of the table such that data is much easier to track (fol More

£20 GBP in 1 day
(183 Reviews)

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.

£23 GBP in 1 day
(109 Reviews)

Hello, I am Excel and VBA expert. One question - what value should be in workbook2 if in worlbook1 is 24 or 40? If you have any questions, I will be happy to answer. Please note that I have 100% completion rat More

£23 GBP in 3 days
(94 Reviews)

VERY EASY FOR ME Hi, Nice to meet you. Please see product I made recently using VBA More

£25 GBP in 1 day
(51 Reviews)

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

£20 GBP in 1 day
(125 Reviews)

Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam More

£19 GBP in 1 day
(38 Reviews)

IS THAT A DIFFERENT WORKBOOK (IN ORIGINAL FILES) OR ELSE SAME WORKBOOK WITH TWO SHEETS.. Because if different WORKBOOK then the workbook name will be used to refer.. I can show you the working version of this formula. More

£50 GBP in 1 day
(29 Reviews)

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

£18 GBP in 1 day
(29 Reviews)

Hi Good Day! A serious freelancer here! I can help you to complete this project in 1-2 days. I have a lots of available time for this work project. Please accept me to this job. I am a vba macro developer for More

£20 GBP in 2 days
(35 Reviews)

Hi, I am an expert in Microsoft Excel including VBA or Macros development. I can provide and develope you a macros which will put the data from external sheet in required format. Looking forward to working with you. More

£15 GBP in 2 days
(12 Reviews)

"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m eff More

£20 GBP in 1 day
(17 Reviews)

Send sheet and get your work done ASAP. I will set to work

£13 GBP in 1 day
(5 Reviews)

Hi! Is it correct data transfer to Workbook2 for february: [login to view URL] I can do this macros easily for the low price. Best regards, Pavel.

£13 GBP in 1 day
(7 Reviews)

Hi. It's Done! If you want I send to you what I did without cost! If is that what you want, you pay me. Thank you.

£13 GBP in 0 days
(3 Reviews)

hi, we already examine your worksheets 1 and 2 for holiday tracker 1 and 2 the raw data is coming from holiday tracker 1, with the date, name and the data itself. we understand that you want to transfer the data fr More

£18 GBP in 1 day
(1 Review)
£18 GBP in 2 days
(0 Reviews)

My Greetings, This is really a too easy task, I will do the Bid just bcuz its a protocol, but well, let's rock' n roll. See ya :)

£10 GBP in 2 days
(0 Reviews)