Data Consensation
€8-30 EUR
Pagado a la entrega
Condensation of a given Excel Spreadsheet by VBA by creating a new sheet
Pattern:
- 1 to 1000 securities in 2 to 7 columns (one of it is date) for each (have a look at the attached file)
- Different starting date can occur ([url removed, login to view] – now)
- Different number of columns can occur
- Last or first day of month can be different to month end or start
Variables to be filled before starting the condensation process:
- Document Name
- Sheet Name
- Date Range
- Each day of date range for example:
o 2nd
o 5th
o 10th
o 50th
o 100th
- Each day of month for example:
o First day of month
o Last day of month
o 3rd day of month
o 15th day of month
- Each day of week for example:
o Monday
o Friday
- Quarter:
o First day of quarter
o Last day of quarter
- Year:
o First day of year
o Last day of year
Result:
- Same arrangement as it is in the given sheet
- In case of missing date
o Data of the day before
o Marked
Must work in Excel 2007 and 2010
No locked VBA Code
Please be patient and flexible if there is an additional wish…
Nº del proyecto: #4990095
Sobre el proyecto
11 freelancers están ofertando un promedio de €23 por este trabajo
Hello Sir, We are a big set up company with excellent skilled operator who have a lot of experience in this segment, our employee complete more than 300 similar job, i have gone through your project specification, i Más
Consider it done. Check my past reviews for your reference. Have done many such projects before. Eagerly waiting for your reply.
Hi, After reading your project description. I am willing to do this job for you and ready to work immediately, following your instructions. Kind Regards, Noushin Jahan
I can write u a tool to achive this, can u accept that? I also can write macro to do this, either way is ok for me, anyway please let me do this, I am efficient .
Sir, i am having 15 years experience, give me one chance i will do this job, and i will deliver with in the time.
STYHI WEB DEVELOPMENT & MARKETING one of the most promising business enterprise and dmaxcreative is an emerging website development, web marketing (SEO) & graphic designing company Jabalpur. Our young & experienced tea Más
i am available for work. Please send me the required so that i can start working on it. Iam good with using excel and i have 2010 version to work on. Will complete the work as fast as possible according to your require Más
Sir I am very interested in your project ..............I would give my 200% in completing this one on time and try my best to give your a satifactory project
I am a new freelancer but I am an expert Data entry I a m a hard worker and so fast I can type in three different languages English, French and Arabic Thanks