Completed

Excel Macro for data shifting--1

I have uploaded here a source file. I contains data of 200 stocks column-wise, e.g. column A to L represent one stock, column N to Y represent second stock and so on.

For each stock there is a time column. Data generally starts from 09:15:00. But for some stocks data may start from 09:30:00.

If time starts from 09:30:00 for a specific stock, then entire data for that stock needs to be shifted downside. A macro needs to be developed such that it checks the start time of each stock and shift the entire data for stock by one row if time starts from 09:30:00. The result is demonstrated in result file.

The 200 stock data mentioned here is for illustration only and is the maximum amount of stock that can be present in a data array. There may be cases where less that 200 stocks may be present i.e. 150 or 162 or anything less than 200.

Skills: Excel, Visual Basic

See more: excel macro data cell, data net web application excel macro, excel data formatting macro, data excel sheet macro, excel macro move data existing cell, excel macro copy data column, excel macro add row fill data, row selection data grid net, adding row wpf data grid, data entry 1 melbourne, data entry 1 montreal, data entry-1, data entry 1, office admin hr computer operator data entry 1 year saudi arabia jobs abroad overseas jobs coimbatore, 1x data entry 1 month extendable convertable ubi $7 hr * * * fast closure * * * d14 eunos geylang paya lebar, data entry 1 parksville, https www freelancer in jobs data entry 1 _e_pi_ 7 2cpage_id10 2c2007737395, kerja free lance entry data gaji 1 jt per minggu, ttps www freelancer co nz jobs data entry 1, 5 Linkedin - data entry 1,000

About the Employer:
( 9 reviews ) JUNAGARH, India

Project ID: #20909806

Awarded to:

Prompty

Hi, i have opened both the files and understood your requirement. THe macro can be developed and will work on static file. I suppose you download previous day or EoD info and work on it.

₹1500 INR in 3 days
(0 Reviews)
0.0

35 freelancers are bidding on average ₹1065 for this job

jugnoosiddiqi

Hi. I have more than 10 years of working experience in this industry. You must visit my field of area and see the level of customer satisfaction through my best in short time working. I can provide you 100% quality ev More

₹1050 INR in 3 days
(0 Reviews)
0.0
vipinrajpoot339

I will do your work

₹1300 INR in 1 day
(0 Reviews)
0.0
mohamedramzan247

hello i am ramzan.i am a very good graphic designer , i have good knowledge in arabic iam very good

₹1050 INR in 7 days
(0 Reviews)
0.0
teerexxx

I love to work on excel n vba I have total exp of 10 I can complete this task within two days Thanks Jitendet

₹1750 INR in 2 days
(0 Reviews)
0.0
sprabu362

i am very good speed typing .i have a good knowledge of account field . i can create a logo in very quickly .i have an experience in data entry.

₹1050 INR in 7 days
(0 Reviews)
0.0
wawawoan2402

Aim a hard worker willing to work hard worked for a top company in USA Disney cruise line where I was training coordinator placing orders schedules and planning and training also work for resorts and hotels can do orde More

₹1271 INR in 1 day
(0 Reviews)
0.0
azeemazard

I am able to fulfill hard tasks within a short period. Has a good computer literacy and well versed with Office related softwares. Experienced in data entry for more than 2years.

₹1050 INR in 6 days
(0 Reviews)
0.0
lynjun35

Hire me and let me help you with your project. I am Computer literate, I know how to use MS Word, Excel, even PowerPoint. Also, I can do Formatting, editing and converting files. In your project, I assure you I can ha More

₹1050 INR in 7 days
(0 Reviews)
0.0
arjob93

Hello! Sir After reading your queries I believe that I am suitable for this work. I am Anand Ranjan. I have 3 years of experience inrelevant field which you are looking for. My Experiences Are..... - Personal Assista More

₹600 INR in 1 day
(1 Review)
0.0
maiWork4u

Hello! Been doing the same job for 5years already. I'm currently working with Real Estate Company doing Data Entry, Skip Tracing, Budgeting & Lead Generation. I am very proficient with Google Docs/MS Suites such as Wor More

₹1050 INR in 7 days
(0 Reviews)
0.0
rajesh1268

I have good typing experience in ms office and I have worked as a Finance analyst, I am available to work any time with a comfortable budget have good experience in Accounting and Data Entry with Excel and words.

₹1000 INR in 2 days
(0 Reviews)
0.0
₹850 INR in 1 day
(0 Reviews)
0.0
huddin06

Data entry proficiency in SPSS, MS EXCEL, data entry and Microsoft office with 3 years of experience from the same field. Excellent proposal and grant writing skills.

₹1050 INR in 7 days
(0 Reviews)
0.0
nomanmaliknm93

Dear Concern i am full filled your project requirement. Kindly give me the chance to used my skills for your task more effectively & Efficiently.

₹1050 INR in 5 days
(0 Reviews)
0.0
₹1300 INR in 1 day
(0 Reviews)
0.0
suryachowdary271

Hello Sir, Ready to start now. I will perform accurate data entries from the provided Image file and input all those details into MS Word as per your requirements and within your targeted time. I am a professional More

₹1050 INR in 3 days
(0 Reviews)
0.0
itsgupta14

I will deliver quality result through my work in quick time Relevant Skills and Experience Data entry, excel , spreadsheets maintaining

₹1300 INR in 1 day
(0 Reviews)
0.0
waqaslang786

Hi I'm skilled worker, I'd love to this kind of job I feel fit for this position. Please allow me to be part of your team, I'm a hardworking working person patient willing to work graveyard shift. Please feel free to c More

₹650 INR in 7 days
(0 Reviews)
0.0
xentricsoft5

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th More

₹1050 INR in 7 days
(0 Reviews)
0.0
Dianahammad

I have the Enough speed to enter high number of data, I work in a larg company in the data entry field. And I hope to be as u think.

₹1300 INR in 2 days
(0 Reviews)
0.0