Vba exel projectKazi
I want excel vba signature form Form for handwritten signs Clear Save And if saved the save will be in the same excel cell I already did it but i have problem with save
I need a development in excel VBA which can data transfer from excel to MS Access and run calculation in access and then transfer excel file, again do some calculations and email result
Hello Rashed... I have this Word VBA/Macro thing... I don't wanna do custom fields by hand.. I want when I open the document, do CTRL-K, and a Dialog Box ask me the variables once, and word put the variables into the document in its place (including in the file name and watermark). I attached the sample Word doc. The fields/variabls for the purposes of this project, are in red, but need to be in normal black in production. Can you help with this? - Gurgen
I need the macro guru for multiple jobs. Details will be discussed.
I have a excel file with VBA already completed -- it works perfectly when file is not is on desktop. However, when file / folder is moved into OneDrive, it doesnt work -- i believe due to the path or location? If you know how to fix, pls message me and I will do screen-share with you to try and resolve via my computer. Need asap. Thank you.
...in developing an add-in for MS 365 Excel for web. The add in should allow for multi select drop down lists, available in Excel for web. Multiple list items should be written in one cell when selected, separated by | (or other separator sign). Desktop versions can offer such functionality by this VBA code: or However, the web version does not support VBA. It seems the web version works with OfficeScript or JavaScrip (via an add-in). I’ve found info that this functionality is not really achievable via OfficeScript (but do tell if I’m wrong about that). Hence the need for an add-in. Details of the add-in’s functionality: 1. Support for many multi
Hi, Pablo-- Hope all is well. I have a new project for you and wanted to see if you're interested. I'm creating a pretty in-depth financial dashboard, with data populated pretty extensively between multiple sheets. Likely several more complex INDEX and XMATCH/MATCH (or a combination of them) functions that will need to be written. It may need some level of VBA. I'm happy to connect if you're interested. Thanks! Jim
I am in need of an Excel VBA solution that can search through 1-10 PDF files for text only. I do not have a preferred alternative software or method for PDF searching. The ideal candidate should have experience with Excel VBA, PDF manipulation, and text extraction. The solution should be able to extract text from PDFs then highlight on the text with red color and draw rectangle rounded then take this page and save it as pdf
I am looking for an Excel expert to assist me with data entry. The ideal candidate will have experience with data entry and be proficient in using Excel. The task involves entering 100-500 entries into Excel. There is no preferred format for the data entry. The job requires attention to detail and accuracy.
Ms Access VBA code to get quote for package from UPS, FedEx and USPS as well as create labels...
I am looking for a freelancer who can build a NAVER Datelab shopping data scrapping tool with Excel VBA. The below is the URL that I want to scrap. URL: The project requires the following: - Scrapping NAVER Datelab shopping list categories and ranking per each category - The scraped data should be presented in an Excel spreadsheet - The Excel VBA code should be reusable for future scrapping tasks * I would like to have a dashboard that I can choose a specific category. When I choose that category and run the VBA, it should show a product ranking list in that category. **I failed to make one per the below video. I am positive that it would not be a hard task. Sample URL:
I am looking for a VBA coder who can help me automate report generation in Excel. Need somebody who has hands on coding experience in VB scripting with automation as needed
...Error that I am experiencing with a VBA Macro using Microsoft 365 Apps for Business Build 2305 (latest) and One Drive for Business Version 23.101.0514.0001 and Windows 10 (updated till date). Problem started last week! The Runtime 68 Error is occurring in several files when loading and input form involves selecting/saving/retrieve path. The same macros worked perfectly on C: drive or whenever onedrive is logged out. Previously worked ok with onedrive..no change in code! Same issue with another computer. Added trust location similar to from regedit: HKEY_CURRENT_USERSoftwareSyncEnginesProvidersOneDrive Ideal skills and experience for this job include: - Strong knowledge of VBA Macro programming and Microsoft 365
I am looking for someone to create an Excel dashboard for my project management needs. The main purpose of the dashboard is to track project progress and identify areas for improvement. I have a specific layout in mind for the dashboard, which I can provide to the freelancer. However, I need help preparing the necessary data and tables for the dashboard. The freelancer should have experience in data organization and analysis, as well as proficiency in Excel, VBA. The ideal candidate will also have experience in project management and be able to provide suggestions for improving the dashboard's functionality.
I am in need of a freelancer who can create VBA code for an Excel Solver project. The objective of the optimization problem is currently unclear, as the client did not answer the relevant question. Additionally, the constraints and limitations for the project, as well as the inputs and outputs, were also left unanswered. However, the ideal freelancer for this job would possess the following skills and experience: - Proficiency in VBA programming for Excel - Expertise in optimization and solver methods - Ability to work independently and efficiently - Strong communication skills to clarify project requirements with the client If you are confident in your abilities to create VBA code for an Excel Solver project, please submit a proposal with...
I'm using to send emails from a microsoft access app. This uses VBA to send via command line. Website was recently moved to WIX and email opperate from gmail workspace, can not get email working. Not sure about how to configure gmail workspace to allow or parameters for
XL-VBA Script Task We are looking for an Excel VBA expert to develop a script to automate routine tasks. The goal of the script is to streamline our workflow Specific Task to Automate: - The user will copy and paste multiple rows in XL (given below spreadsheet). The script will: -Engage either through a button or automatically. - Loop through single or multiple columns to find identical, repetitive strings and then reassign a sequential id value (string). - Loop through single or multiple columns to find and correct repetitive parent-child id values (strings). - Only pre-tested (for QA) submitted scripts will be fully awarded. Zero tolerance for bugs
I am looking for a VBA expert to help me with webscraping from a specific website. I need the scraper to extract specific data and export it into an Excel spreadsheet. The ideal candidate should have experience in VBA and webscraping, and be familiar with the website I want to scrape.
I am looking for a VBA expert to help me with webscraping from a specific website. I need the scraper to extract specific data and export it into an Excel spreadsheet. The ideal candidate should have experience in VBA and webscraping, and be familiar with the website I want to scrape.
I am looking for an experienced Excel user to help me design a reusable workbook. The purpose of the workbook is mainly for data management/analysis, and I have a specific layout in mind that needs to be followed. The workbook should include some advanced features such as Data Validation, Pivot Tables, and Power Query, Power Pivot, or Macros/VBA. This workbook should be reusable and should include all necessary coding and features necessary to achieve this. It should also be user-friendly and intuitive, with easy-to-follow instructions. If you have the skills and experience necessary to successfully complete this task, please apply.
I am looking for a freelancer to help me with some ExcelVBAwork. The main purpose of the project is data analysis, specifically medical data. I expect the freelancer to analyze between 1-5 sheets of data. A strong understanding of Excel and VBA programming is required for this project. I look forward to working with someone who can help me to complete this project quickly and efficiently.
I am looking for a freelancer to help me out with a project. I am upgrading my MS Access application to Windows 11 and need assistance in changing the application icon. I already have an existing icon selected that needs to be replaced. However, I will need assistance from someone familiar with VBA code to make this change. So, if you have experience with VBA coding and have worked with Windows 11 applications before, then this might be the perfect project for you! I'm using the following version of access: Microsoft® Access® for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20002) 64-bit. I'm currently using this code, but the Access icon is still displayed in the main window on windows 11: "AppIcon",
Excel VBA for network and sub network generation
...columns of data to a new CSV file. The exported file must be in CSV tab delimited format. The criteria for selecting the data to export will be based on specific columns. I also need the macro to match data in the other 4 sheets and delete certain rows based on criteria before exporting. Ideal skills for this job include experience with Excel macros and proficiency in VBA. Match, Delete and Export Excel 365 Macro This project is based on the enclosed sample active workbook, which has the following worksheets (one in each tab, labeled: Cases, Casework, Comments, Contacts, plan_request The macro should run in Excel 365. The macro should basically delete all the entries from a specific “Issuer State” (eg: HI “Hawaii”) from all the worksheets wit...
Excel Macro to run on Mac Hello, I have a macro that works well on PC but not Mac. The macro is simple; it launches a user form that has list when the user clicks on a cell with data validation. Row source doesn’t work in Excel Mac. Many columns could have different validation lists:ranges. Again, doable in Excel Pc....not Mac. The macro is simple; it launches a user form that has list when the user clicks on a cell with data validation. Row source doesn’t work in Excel Mac. Many columns could have different validation lists:ranges. Again, doable in Excel Pc. Ideal skills and experience for this job include: - Proficiency in Excel and VBA programming on Mac I am open to discussing additional requirements and details with potential freelancers. Thank you for your int...
We had a freelancer who we've used to make many spreadsheets and calculator tools who has not had time recently to help with turn around projects quickly, so we are looking for another person. This current project is a calculator tool used for budgeting projects. We need to create validation rules, a few math expressions, and then pivot tables and reports. We want to be able to have people use this tool without needing to worry about worrying about viruses, so we are not using any macros or vba. Aside from skill with Excel, the person we select needs to have excellent math skills and be good with large number and data sets.
Ich möchte eine eigene Software für Physiotherapieabläufe und Abrechnungen erstellen lassen. Ich benötige viele „wenn dann“ Parameter die ich hinterher frei verändern kann. Beispielsweise wenn es neue Regelungen gibt wieviele Behandlungen auf einer Verordn...Terminzettel, Quittungen, Arztbriefe, Rechnungen für Privatpatienten Integriertes Kassensystem Am besten wäre der Abrechnungsbereich auch mit integrierter Import Funktion von Krankenkassentarifen, die sich immer wieder ändern. Das Ganze sollte ein Admin Backend und ein Support Backend haben. Im Support Backend sind dann tiefgreifende Veränderungen möglich. Wichtig ist dass viele Bereich mit Exel Tabellen importierbar und exportierbar sind. Vordrucke sollte im do...
...Load this file in C:UsersUserAppDataLocalTemp Please note, the PPAM and PPTX files listed here will get changed later. As of now, these are sample files for testing. The deliverable: EXE file - Similar to the file () Full Visual Studio Project/Solution folder so I can modify it on my end. ********************************************************************** Scope 2: After successfully completing Scope 1, we will move to Scope 2. This is a bigger phase of the project and it involves a) Integrate VBA scripts in the EXE that we built b) Download Files to disk c) Load PowerPoint files from the URL d) Integration with Azure e) SSO integration I will provide detailed instructions when we move into Scope 2. **************************************************...
I have an Excel sheet and want to dynamically fetch data from some rows and display user forms accordingly. I have an Excel workbook, it has 4 sheets. 1. General: in this sheet, the user can enter different space types at the bottom. So what I want is, as the space type is entered, dynamically buttons are added on the second sheet (mechanical), with names the same as the space type names the u...names the user entered in the general sheet. now when the button is clicked I want a form to be opened in which the user can enter values, and those values are then pasted on the specific cells, and a similar should happen in other two sheets named electrical and plumbing i have already done the dynamic creation of buttons but i am stuck on how to trigger the on click and display the user form in ...
We have an online excel document that tracks all our jobs going through our workshop. we need to be able to take data from specific lines in th...print that data on a label. The excel data is getting updated all the time and the labels are printed immediately after updating so we cannot use standard label printing software as it does not pickup the changes quickly enough. I am looking for a developer who can create a VBA or software solution that can print labels using live data from an MS Excel document. I have a specific label format in mind that I would like to use for this project. The ideal candidate should have experience in Visual Basic for Applications (VBA) programming language. The labels will contain text only, and I am looking for a solution that can han...
Excel VBA Visual Basic Data Entry Word Web Search
We have a sheet that contains dtaa for invoices. we need to insert a row so we charge for carraige for each new order line. some orders contain mulitple linesbut we only need one carraige charge. The data is in same row as the order line To acheive this I have a sheet that we then take the data and I have put into new sheet, we then need to insert a row ina new sheet if a cell above changes, you then need to take a cell in that row and insert in new sheet. Adding delivery to each order insert a delivery row using the info from the first line of that order number Every time column K changes insert line P= =='order-item-details (14)'!AE21 T = 4014 S='order-item-details (14)'!AH2 U= “20%(VATon Income)” AB= “Invoice”
I need professional in VBA EXCEL to do the following One excel file can read any excel file Then summarize it with progress and other details which can be written manually
I am looking for a freelancer who can provide a VBA function in my spreadsheet to call the ChatGPT API. The spreadsheet is written in VBA. I require basic functionality only for the integration and the intended purpose is automated data entry. The ideal candidate should have experience in VBA programming and API integration. Specific skills required for this project include: - VBA programming - API integration - Basic understanding of ChatGPT API functionality
It's urgent! Hi, I have an excel sheet and i want to dynamically fetch data from some rows and display user forms accordingly. Thanks
Nous avons développé un fichier Excel avec VBA pour aider les entreprises à identifier leurs hauts potentiels. Il s’agit d’un formulaire qui se compile et qui calcule les cotes données par les gestionnaires pour positionner l’employé dans un graphique et le comparer avec les autres membres de l’équipe . Nous souhaitons transformer ce fichier en application que nous voulons vendre aux clients. Nous souhaitons que la personne nous aide à : - améliorer notre outil au niveau de la présentation des résultats - le convertir en plateforme accessible sur cloud - les gestionnaires doivent pouvoir avoir leur propre accès (user et mot de passe) pour accéder aux résultats de le...
In spreadsheet , Column F (Field2) are a list of Youtube channels. For each channel, we want the scraper script to find the Youtube URL of the channel. For example, in Row 2, the URL for 滾石唱片 ROCK RECORDS is @RockRecordsTaipei . Candid...com/spreadsheets/d/1GmYRNUvKt_i80B_fxsP09Ajau-cQ7iaHvRkHNMGiDi8/edit?usp=sharing , Column F (Field2) are a list of Youtube channels. For each channel, we want the scraper script to find the Youtube URL of the channel. For example, in Row 2, the URL for 滾石唱片 ROCK RECORDS is @RockRecordsTaipei . Candidates should state on which platform they plan to use, such as Google App Script, VBA, etc. Thank you
Hola, tengo una hoja de Excel y quiero obtener datos dinámicamente de algunas filas y mostrar formularios de usuario en consecuencia
I am looking for a freelancer to create a VBA coded Excel sheet to track test results for my medical history. The sheet should include charts or graphs to visualize the data. No security measures are needed. Ideal skills and experience: - Proficiency in VBA coding and Excel - Experience with medical data tracking - Ability to create visually appealing charts and graphs for data visualization
Criar código vba para um UserForm cujos dados explicativos serão enviados via chat.
Create vba code for a userform the explanatory data will be sent via chat.
I'm in need of a freelancer to help me automate a specific excel file and will require advance excel skills (VBA & Macros) . The project is for personal use and the specific task I need help with is performing calculations/formulas. The automation should be set up to be compatible with the latest version of Excel. Additionally, I would like it to have as few errors as possible and to be efficient so that the file runs quickly. If you can help me create an Excel file that is accurate, efficient, and compatible with the latest version of Excel then please reach out.
I have availability calendar hosted on my service provider. Needs are as follows: 1. Read current availability situation from web calendar 2. Mark blocked / available dates to excel spreadsheet (Master calendar) If a date range is needed to be put blocked / available, there is also a need to: 1. Block availability in web calendar to date range 2. Open availability to date range More detailed information attached with screen shot from the application and Selenium IDE recording. Temporary access to calendar is given for developement. Service provider does not have API to control this.
I cant disclose it i want an excel expert with vba knowledge for creating a frontpage of my data base
I have an excel sheet and i want to dynamically fetch data from some rows and display user forms accordingly
I am in need of a skilled web scraper who can update soccer fixtures from William Hill and Ladbrokes. The scraped data needs to be cleaned and organized in a spreadsheet format. The ideal candidate should be familiar w...web scraper who can update soccer fixtures from William Hill and Ladbrokes. The scraped data needs to be cleaned and organized in a spreadsheet format. The ideal candidate should be familiar with web scraping techniques and have prior experience in working with soccer fixtures. The project requires scraping data from all available leagues and tournaments. I have a web scraper that I am currently using in VBA and I need a hyperlink to be scraped and added to an additional column. This is an excel and VBA project. I will send over the excel spread...
I am looking for an Excel Macro expert who can help me automate tasks. The main goal of this project is to automate various tasks that I have listed in detail. The tasks are of intermediate complexity level. Ideal skills and experience: - Advanced knowledge of Excel Macros - Strong understanding of VBA programming language - Experience in automating tasks in Excel - Ability to work with data analysis and formatting - Attention to detail and accuracy in coding - Good communication skills to understand my requirements and provide suggestions for improvement.
I can explain on call, we need VBA excel template to get possible all combinations from multiple columns