Simple VBA code
$10-30 CAD
Paid on delivery
I need to make a VBA macro to do the following
1. Make a loop to go through from beginning to end of the list on Sheet 'List'. The total amount of rows on this list is is not fixed.
2. Populate data from 'List' sheet to 'Upload' sheet with the following conditions. Do this until the end of the list.
a. 'ID Type' will always be 'SEDOL' for every row
b. 'ID' will be SEDOL column from 'List' sheet
c. 'Instruction' will always be 'Propose Quantity' for every row
d. 'Value' will be 'Buy/Sell' column from 'List' sheet
3. Populate 'Locate' sheet based on the following
a. Leave CUSIP, ISIN, RIC columns blank always
b. Populate SEDOL and QUANTITY column based on SEDOL and Buy/Sell column from 'List' sheet
4. Button to save 'Upload' and 'Locate' sheet as .csv file
Project ID: #27864358
About the project
Awarded to:
13 freelancers are bidding on average $25 for this job
Hi, How are you? I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well. If needed, I first can do a demo and send it asap. And then you can see it and decide on this project More
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours
Hello, i have good experience in excel vba , i read the job description , i can help you to do it contact on chat Regards, Ahmed Sobhy
hello, i have expertise in excel vba. and can get your job done. message me to discuss further about your requirements
Hi there, Gone through the job details and happy to help you. I am an expert in excel formulas, dashboards, macros.I will be able to finish before the deadline. Thanks Arun
Hi! Thank you for the detailed description. I will be available for such work during next days. Best regards, Jakub
All your requirement are very clear from project details and I have no further questions to ask. I would appreciate very much if you will give me the opportunity to complete this task. If my bid is accepted, I am rea More
I have read your requirements. I can do your project. I have 7 years of work experience in Excel, VBA, macros, access and SQL Server.
Hi - I am a Excel Macro Developer and .Net Developer. Looking for a job that will help me grow and i think your project might be fit with what im looking for. Thank you.