I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates.
We will provide a set of input files in a folder. Each of the input files need to be read from the folder and based on logic, needs to be converted into another format (excel sheets)
... - We want the project owners to input their update into SharePoint and pull that into this workbook, mapping to the data elements in the dashboard - We want to leverage a VBA button to produce a PowerPoint slide of the dashboard to automate our deck production. We hope you will accept our offer and look forward to hearing from you soon. Please let
Non-profit business needs spreadsheet to track weekly contributions that will link to Annual total page for each parishioner. Also, spreadsheet needs Master worksheet that allows the addition of names that will automatically update each subsequent worksheets.
I want a vba code which can be installed in users pc. Which will expire after 1 year and on the expiry they should need to ask me for the licence key again. The programme should not work in another pc.
Write a VBA/Macro Using Excel for analysis a huge number of property information, including all particular, Historical and Current rental status, Rate of Return, Historical and Current Market Value, Profits or Loss and Banking Facilities Information for each of the property.... Steps 1. Design "Master Data Sheets" to contains all information 2. Design
I want to automate 2 reports via VBA Macros as follows (A) AUTOMATE MONTHLY SALES REPORT ANALYSIS A monthly sales report. My Report has the following fields (See attached). My interest is for you to develop a VBA macros script which will automatically on running the script generate the following reports (See attachment) (1) Sales Revenue Analysis
...have 2 excel sheets, which are a copy of each other. One is saved on my local drive (My Laptop), and the other is saved on my google drive. In the sheet saved on the google drive, a colleague can go ahead and change values in certain cells. Currently I have to download the sheet from google drive, look at the changed values and then update my excel sheet
Attached is a spreadsheet that has readings from the new data site. Every site can have up to 3 sensors (identified by a sensor #) connected to a base (identified by a base #). I need a blank spreadsheet where the user can input the following: Input: Base #, Sensor # (or all sensors connected to that base), Date (single date). The spreadsheet would generat...
Microsoft Excel VBA coding that needs 1. Add, update and retrieve member’s details such as name, date of birth, NRIC, contact number, residential address, email address, etc. 2. Member must be at least 18 years of age. 3. One-time membership fees of $50. Payment by cash or credit card. 4. Discount rates to member i. 5% discount to the total purchase
I need for multiple VBA modules to be converted to C# and compiled into two standalone addins. Part of this will require for the user to be able to perform CRUD operations to SharePoint online lists, which will require for the users login credentials to be passed automatically when necessary.
Trying to create/populate a database using historical racing results. Need to scrape data (tables) from website into MS Excel. All details in attached MS Word document.
Dear all, I need a vba run excel file manager to be drafted with following functionality: 1/ list file names from the selected folder + subfolders 2/ list location of the file 3/ hyperlink to the file 4/ once list is generated, ability to change file names in the list that would automatically change names in selected folder and subfolders. So basically
I need to manipulate a data file I will receive each month (similar to attached). The data file includes a list of managers (Column B-D) and all of his direct reports (Columns H-AB). I want the file to create a table from the original showing a summary table detailing each managers direct reports on a seperate row (see summary sheet for example). The example below has 3 rows of data, but the ac...