Need an excel macro to get prices from website into excel
Financial/Business analyst ,Excel Macro expert needed for some task .
Hi freelancers, in the attached file I want a VBA code to do the following: Check all cells from W37 to the "last row" in the sheet. If any cell in that range contain date less than 1-1-2018 , the next two cells in the same row must be protected. For example cell W40 in the attachment has the date 22-Sep-2017, then cells Y40 and AA40 must has the format
Retrieve Market Capitalization and Volume values from Total Market Capitalization chart, that can be found here: [url removed, login to view] Data must be spaced out by five minute intervals. (as it is from 1 day charts) Deliver data in XLS format. "Date", "Time", "Market cap" and "Volume" must be organized separated columns. P...
...created with TextArea Element and Pictures. 2 .I have spring mvc portlet which will retrieve all the content from WCM (Example I can get title and text Area of content using portlet classes). I have used all WCM apis to do it. 3. The requirement is I want to write a code jsp to get the list of titles with hyperlink and when click the title link it has
My website is unable to process emails messages through the "contact us" link. I need someone to look into this matter as well as install a captcha. Thanks you
I would like the highest and lowest rating in column R found and the the whole corresponding row copied to a blank sheet. This needs to be done for all sheets in the workbook. Please check screenshot for more information.
...an email every morning that contains 25-100 links with data on real estate. 1. Each link in the email needs to clicked on, and then the subsequent page needs to be printed to PDF. I would like to have each file labeled with the current date, then “(LN)”, then the id used in the source code of the link. (i.e. 2018-02-14(LN)630-S-Pacific-Ave-San-Pedro-CA
...(PRODUCTION) C) IT WILL BE STORED ON A NETWORK D) WHEN SOMEONE GOES IN TO MAKE AN UPDATE, I WANT THE MACRO TO DO THE FOLLOWING: 1) SAVE THIS ORIGINAL MASTER FILE ON THE NETWORK (I'LL UPDATE THE ACTUAL PATH, BUT I'LL NEED YOU TO SIMPLY WRITE C:PATH IN YOUR MACRO, OR SOMETHING SIMILAR) 2) COPY THE PARTICULAR SHEET THE END-USER IS CURRENTLY EDITING TO A NEW
I receive a PDf every week and I need to copy the sales data from the PDF to Excel. I am looking for a Macro that can automatically copy the data and format it into the excel table. please see the attached PDF. I need the data from Page 3. Do not BId more than $30 as that is the maximum budget or else i will delete your BID. Thanks
...spreadsheet where I run a macro to find the best possible combinations, I think the total number is 144 Million different combinations. I need to run through all these combinations(Cells H3-N3) to figure out the best possible combinations(finding which combination leads to the best ranking correlation(Cell R2)) for finding historical data points. If you look
I am looking for someone to build an Excel Macro. The Macro will take upto 5 csv files. It will take a particular column from the csv files, combine into one and remove all duplicates. This is a list of words. I want option to be able to filter out based on word count (from 1-8 words in row) Macro should have option to put in a list of words that
...waste your time, or waste mine. One of the projects I have done is web-scraping property values from [url removed, login to view] - pulling existing "zestimates" (estimated current values). Now, I am looking to see if someone can re-write the macro to determine which of these addresses/data points in the saved .CSV file is currently on SALE by agent or by ow...