Finalizat

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.

Aptitudini: Excel, Visual Basic

Vezi mai multe: 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

Despre angajator:
( 11 recenzii ) JUNAGARH, India

ID Proiect: #20909806

Acordat lui:

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.

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% INR în 3 zile
(3 Recenzii)
1.7

33 freelanceri licitează în medie 1045₹ pentru acest proiect

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 7 zile
(1 părere)
0.8
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 3 zile
(0 recenzii)
0.0
vipinrajpoot339

I will do your work

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR în 1 zi
(0 recenzii)
0.0
mohamedramzan247

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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 7 zile
(0 recenzii)
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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 7 zile
(0 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR în 1 zi
(0 recenzii)
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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 6 zile
(0 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 7 zile
(0 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR în 1 zi
(1 părere)
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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 2 zile
(0 recenzii)
0.0
%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR în 1 zi
(0 recenzii)
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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 7 zile
(0 recenzii)
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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 5 zile
(0 recenzii)
0.0
%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR în 1 zi
(0 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 3 zile
(0 recenzii)
0.0
itsgupta14

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

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR în 1 zi
(0 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 7 zile
(0 recenzii)
0.0
isrm98489

Understood the requirement . will try to n give the results in time frame given. worked in excel. thanks

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 7 zile
(0 recenzii)
0.0
soumyadipc05

I AM ALSO A STOKE MARKET TRADER I HAVE DONE THIS ALREADY BEFORE IN MY7 COMPUTER. WITH EXCEL IF YOU WANT I CAN ALSIO ADD SCANNER ON ANTHER SHEET LIKE OHOL 3 HHC etc. AND ALSO YOU GET LIVE UPDATE. IF YOU WANT

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 5 zile
(0 recenzii)
0.0
iqra419

I'm a work alcoholic.. please prefer me to accept these project..I have good knowledge in ms Excel, typing and word

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% INR în 9 zile
(0 recenzii)
0.0