Excel vba jobs
Same as title. More details on chat.
i am looking for API Expert that has experience in Ewelink API This is the device that I want to automatically export data to a Google sheets This device now can export Power Consumption History to Excel, But need to do it manually every time. i need help to perform this task automatically every day (example)
I need a web scraping expert who can make leads and put them into an excel sheet. it will be long-term if I satisfy with your work. Thank you.
I'm looking for a personal trainer who can help me learn python from scratch in a practical approach with real-time examples. The pay will be hourly or fixed based on estimated duration and curriculum. will need 2 demo sessions. The goal of me learning python is to automate few redundant daily tasks on Excel, Browser and a few web apps. Eventually to automate simple and small trading strategies. We can talk more if you are interested. All communication will be via Freelance & Zoom only.
1. After api level 29 excel file export is not working in app (need to use media store api) 2. In app 45 rs monthly subscription system is implemented but many time it is charging Rs. 0 subscription being successful (need to solve ) App link:
We have lots of CV's (RTF Format), we need to scrap all the details from the first page, and scraped data should be converted to excel sheet data base. We have attached some CV samples for the reference.
Looking for someone to create an excel workbook for purchases, sales and bank ledgers.
I want to edit the existing macros code to receive email alerts for additional conditions. The existing macros with email notifications for certain conditions already work.
Greetings! Our team needs customized schedule running on our own domain. It is very simple, with a few drop down lists and it doesn't need to be anything special in design, just with good clarity and usefulness, since it is going to be used only internally. I have attached an excel file with an example of how it would be perfect for us. There are more details in the file, but feel free to ask me if the instructions are not understandable. Please let me know your fixed price for the project and how much time it would take.
Developer needs to develop a code in python to import live data in excel form nse india website so that it can be imported using power query for further analysis
I have a quoting excel sheet from a different company. I want to make something similar.
We are an architectural firm based in mumbai, we need to create interactive dashboards and publish on web for performance related to the firm and teams Woking
...identify trends and patterns in the current operations. You will submit a written current state analysis report. You will also create multiple charts to present the descriptive analysis you performed. To organize this information, you will create and submit a Data Analysis Workbook in Excel. For this milestone, you will add three sheets to the workbook, and you’ll add more as you complete your Milestone Two assignment. Specifically, you must address the following rubric criteria: Descriptive Statistics: Create an Excel file and title it Data Analysis Workbook. Within your workbook, create a sheet titled P1_Descriptive Analysis. Present descriptive statistics (mean, median, standard deviation, and range) in a table for four attributes from the data set. Analyze the ...
I want to edit the existing macros code to receive email alerts for additional conditions. The existing macros with email notifications for certain conditions already work.
kindly, check the file and give the review, thanks.
Hi! I would like someone with the expertise of Macro excel to create a simple system for me. I have the design ready but the buttons need to be coded. Basically, need the system to search a data from textbox in excel and display a different data to another textbox. Please look through the PDF file for more info.
Need to migrate data from a cost and project specifications spreadsheet with 10-12 workbooks into a formal proposal document for our clients. I would the like the ability to convert the proposal into a contract.
Hi, I need to automate a weekly email that sends all my colleagues a template that feeds from an excel file which contains tables and pivot tables with the info. The template has a response option that should save their answers in another excel file triggered by a botton. The email should be matched first where my colleagues ONLY recieve emails with the template of sellers that operate in the same country. For those colleagues that are from the regional team (REG) they can recieve templates from sellers of ALL countries. The possibility that comes to mind is through Macros or VB but open to any other solutions
...0other%20rich%20media%20features Main analysis items of interest would include: - Monthly active chatters - Number of messages per active chatter And possibly others. Nice to haves but not required: - Experience doing similar analysis on Discord - Strong scraping and text + data processing skills - Decent skills with spreadsheet software appropriate for the tasks (ideally Google Sheets, but Excel or Numbers also acceptable) - Ideally can put in hours through this weekend Jun 25/26 to move as quickly as possible - Count of use of specific keywords in a given month To apply, please write a very short description of your skills and experience relevant to the task. Also mention which tools you think you would use to complete this task and give a super rough ballpark hours estimat...
I have an excel file where multiple values are stored in a single cell. in a column (I). I would like each entry to be in a unique row in that column .
If you offer a low price just to raise it later in the dialogue - I will select another freelancer and block you. We need to have all contact info from the following website " ;jsessionid=B906F79CE2694AF47AC0C9DFE70CA4D9.2_cid379 " Each entry must state the following info as applicable: Type (Leitung, landesverband, regional stellen, ortsverbände, ausbildunzentren) Title Adress Post code City telephone email (press link and it opens in a mail) Manager name (you need to click the department name to get this)* Web site (if applicable) * There are around 700 entries
Create a simple system where jewelry repair orders can be captured. It needs to allow to enter the item, picture of the item by connecting a camera as well as information of the customer including phone number Attached an example from an existing system. It should generate a ticket for the repair order that can be printed to provide a copy for the customer and a copy for the shop to incl...a ticket for the repair order that can be printed to provide a copy for the customer and a copy for the shop to include in the repair bag Main points we want to control is the items included, the date received and promised and the status of each repair. We should be able to list what is pending to work on and what is ready to be pick up by the customer. Want to be able to export the data in ex...
I am a general contractor and I need to make an excel sheet that contains a massive list of all my subcontractors. I want to create a way to filter my subcontractors by construction sites they are working on with a click of a button.
I have a file with 2 sheets for Members of Congress and Constituents. I am trying to populate a row of multiple constituents who are affiliated with the congressman. The sheet with Congressman lists their constituents in a column, and I need them to be populated in a row on the Member of Congress sheet. I have tried INDEX, VLOOKUP, MATCH, etc but cannot get multiple names to be in a row on the Congress page.
I have a file with 2 sheets for Members of Congress and Constituents. I am trying to populate a row of multiple constituents who are affiliated with the congressman. The sheet with Congressman lists their constituents in a column, and I need them to be populated in a row on the Member of Congress sheet. I have tried INDEX, VLOOKUP, MATCH, etc but cannot get multiple names to be in a row on the Congress page.
I need the reviews from: (all 33 pages) put into an excel sheet please with the following table headings 1) unique reference (to be sequentially generated) 2) name of reviewer (follows “by” for each review) 3) date of review did/mm/yyyy 4) star rating of review (1-5) 5) verified purchase (yes or no) 6) title 7) review text 8) dealer response where applicable (see for example page 6 review of 04/10/21)
Hello, i need help with the design of a background for my Excel sheet. The sheet is for my Online-Fitness coaching, in which I create nutrion plans for my customers. The bottom right should say "Coaching by Lando Stecher". and a Logo with my name "Lando Stecher" The design should be minimalistic, clean, have blue or green color accents. in the attacment, you can find my information, which should be on the design. The sheet is printed in PDF format. The pages are already customized in the template. Thank you for your help.
Hello, I need to harvest from the following links, go to each company profile, get the company name, phone number, then their website and email (from their site). From the following links: Output in excel file.
Integration between form (eform plugin for wordpress) and table with formula as excel (spreadsheet) and charts.
Need an Excel sheet created of the current contracted Plumbers in Miami Dade Step by step below and example of format attached in pictures- 1. Visit 2. Click 'Verify A License' by License Type 4. MUST SELECT License Category: CONSTRUCTION INDUSTRY License Type: CERTIFIED PLUMBING CONTRACTOR City: MIAMI State: FLORIDA *CLICK SEARCH* - LIST OF BUSINESS NAMES WILL APPEAR- from this website you will get the information for the business name and owners name. Excel sheet needs the name of business, the owners name, CURRENT phone number and address PHONE NUMBER AND ADDRESS MUST BE FOUND ON GOOGLE. IF CANNOT FIND, LEAVE BLANK. ANY QUESTIONS OR CLARIFICATION PLEASE CONTACT ME
I want an online nomination for students to select their track and field events. The online form then pushes the data into a spreadsheet with designated column names and automatically creates a csv file (text file) for import in to Hytek Meet Manager It takes too long. I need online option that data Automatically goes in and creates a text file (CSV semi colon)
We're looking for a scaping expert that is able to help us: on a specific website each page contains a NAME, Profession (such as Dentist etc), Address, ZIPcode, City, and Phonenumber. We would need to receive the export, in form of an excel file
We are currently working with an Excel spreadsheet + VBA for automated processing of our online orders. The VBA script scraps the data from our wordpress/woocommerce store, enters it into the spreadsheet, mails the orders to the suppliers, puts the mail in a folder on the server, updates order statuses and exports data for accounting. In the future, these operations should be performed not by VBA, but with the help of Office Scripts and Power Automate, so that we can work with the table from MS Teams. The VBA scripts are all viewable and can be used as templates. However, it would be desirable that the developer not only adopts the code 1:1, but also critically scrutinizes it and makes suggestions for improvement.
Hello everyone I need quick help for Excel macro. Deliverables Macro in Excel Visual basic. Template is preloaded into excel. Send specific instructions to a website to populate specific categories and receive back a generated report. Able to extract information from it and be able to populate to a pre-set template Will discuss more in chat . thanks
Good Morning, We need someone to do some data entry for us. We have 900 photos which need to be added to some reports using word or excel (your choice) all photos are currently referenced by a number/filename - The photos are currently sorted in folders (40) each folder will have a document that need have the photos of each folder added. Row A - File Name, Row B Photo, (Row C and D are areas we will edit. I know using excel this can be automated i am unsure about this so how ever you get these into a document and to complete the works is up to you All photos will be available on SharePoint. Attached is how we currently have our document - if you can make it look better than what it is this will be a massive bonus
We need help with change header field and chnage prices in excel task. Very easy task Write what expirence you have with Excel when you bid
Hi Basically we are looking for Excel exports with macros enable data. We are maintaining the data in excel for Incentive calculations. For that, we need automatic data to need to capture how many incentives where they have achieved the target. and how much the manager has achieved and how much the manager has got incentives. In detail, we can discuss this once we connect.
I have a folder with 6000+ xml files, all structured in the same way. I need to import them into MS access in order to have a more useful database. I manually imported a couple of them, however I would now like to import the rest in an automatic fashion. The xml files need to be appended to the only table in the access file. The xml files are named in sequence with the following structure where the suffix MGPPrezzi obviously does not change. The files start from 20050101 and end 20220624: some files are attached so that you can test the script. I am not sure if there are missing files, should the file be missing, the script should write down the filename/date in a (single) txt file or in a separate table, and fill in the 24 rows (hours) for that day with an empty cell. Not a N/A, not a ...
Convert the current database into microsoft access. Allowing users to enter data easily and for the database to be able to crunch the numbers and produce simple reports. Also to be able to search the database easily and bring up the values required.
Need a romanian native for: - I have a list of products in Excel (washing machine, gaming keyboard, microwave...) - I need you to delete the words that do not have to do with transactional products (Example of words to delete: repair washing machine, washing machine error, technical assistance washing machine...) It is very simple.
Hi, I need to covert a scanned document (maybe you can use OCR) containing data to excel format. There are 46 pages same as the sample jpeg attached. Please add "I LOVE PDF" to the start of your bid so i can filter out auto bidders.
Integration between form (eform plugin for wordpress) and table with formula as excel (spreadsheet) and charts.
The trainer should have knowledge of the following: Business Accounting/ F.O.A/ F.A Tally Prime Quickbook Advance Accounting Advanced Excel GST TDS ITP MCA/ ROC & LLP Business Communication IFRS & Ind AS Costing & Auditing
Integration between form (eform plugin for wordpress) and table with formula as excel (spreadsheet) and charts.
I want a custom Amazon product viewer integrated into my Wordpress site. I want to be able to load an excel sheet of Amazon product information into a database and users will be able to browse and filter my data on my website. A good examples of the type of product viewer is from Keepa. I would like the product viewer interface to be similar in function to Keepa. You must have work samples similar to what I am asking for. I would like to see a similar product that you have created. PLEASE READ THE PDF DOCUMENT to fully understand the project details and properly quote me a price and time estimate. Thank you.
Due to a promotion in our team, we are hiring another business development manager to take over a mix of existing accounts and new sales territory. To excel in this role you should be an active listener, have a compelling sales personality, and a hunger to chase and close new business from cold calls and inbound warm leads. Business Development Manager Responsibilities: Contacting potential clients to establish rapport and arrange meetings. Planning and overseeing new marketing initiatives. Researching organizations and individuals to find new opportunities. Increasing the value of current customers while attracting new ones. Finding and developing new markets and improving sales. Attending conferences, meetings, and industry events. Developing quotes and proposals for clients. De...
We need someone to create individual PDFs of 12,000+ news articles. All web page links are saved in an Excel document and ready to go. Each PDF will need to be saved with the date (YYYYMMDD) at the beginning of the file name, followed by whatever else is there as the file name. Project will need to be completed by 1 July. Detailed instructions will be provided at the beginning of the project.
