Hi
I have got a couple of questions
First one from given data sheet, i need to separate "for example " row 3 into 2 rows first row contain 2 days of leave period and the newer row into 0.5 with same other data ( any row that contains fractions value in Column D , must separated into a row that contains decimal value and another one contains the fraction)
i already made another helper sheet since my data is generated from a system that has a fixed excel form.
Second question, when pulling employees data i need to get rid of holidays as shown from column A, according to table in G:H columns
for example 25/1 was a holiday, when my helper sheet is populated it automatically don't record the who row.
I have got a couple of questions
First one from given data sheet, i need to separate "for example " row 3 into 2 rows first row contain 2 days of leave period and the newer row into 0.5 with same other data ( any row that contains fractions value in Column D , must separated into a row that contains decimal value and another one contains the fraction)
i already made another helper sheet since my data is generated from a system that has a fixed excel form.
Second question, when pulling employees data i need to get rid of holidays as shown from column A, according to table in G:H columns
for example 25/1 was a holiday, when my helper sheet is populated it automatically don't record the who row.