Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
I need some help with EXCEL. Attached are two billing statements: 1) September 2022 2) December 2022 I unintentionally mixed up what should have been separate EXCEL bills into one. In the case of September, I should have billed two different entities and instead I billed one. For September, I need to separate P (Personal) and CMJ (CMJ) into two different bills, for “Personal” and “CMJ”. For December, I mixed up three entities: WM WM Wholesale CMJ CMJ P Personal For December, I need to separate P (Personal), CMJ (CMJ) and WM(WM Wholesale) into three different bills, for “Personal”, “CMJ” and “WM”. The attached scans have all been marked. Please prepare two billing statements from the attached September bill and th...
So my need is to have my orders at one place Like if we could create a Excel where I can put Image clicked from my phone and put it into Excel which can neatly present data with field like Image Order Qty Customer Name Date of Order Current Status Customer Notes It should look professional and can be modified in future for extra field
Analyse VBA Code (excel Macro codes), and help objectives to running a macro, including figuring out which parts need to change on existing Macros, and tweak / modify as needed. You will need to train on the call how to resolve specific issues as they will have multiple questions. It will be based on existing Excel Macro.
i want a freelancer make script at excel to get balance multi account at binance by api spot , future , margin i know many add one but i want a freelancer make it and show it to me
I need a marco to randomly select 42 or so lines from 2 different columns and put them into a template on a new sheet in the same workbook with fields for QTY and DATE, the item numbers and bin locations will come the first sheet. The items selected have to be different everytime unitl the list is complete, then start all over
I am looking for someone to write a script for Microsoft Excel which I can use do remove specific rows and columns from a spreadsheet. It needs to work on a Mac computer. Please watch this screen recording video where I explain exactly what I need
I have (in sheet TEMPLATE) a list persons with data for each person and I want to copy the data from this person to sheet 'DATABASE' and fill in all months with the template value when I click the checkbox 'Fill in all months with this value?' The same is between 'Editing values' and 'Database' sheets.
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun
Hola, estoy buscando un programador o usuario experto en excel que sepa programar un libro de excel en 2 hojas, o 1, y en el que pueda plasmar un estudio de rentabilidad del proyecto a nivel de inversion, es decir, las cantidades a invertir totales respecto a las cantidades a recibir una vez se vende el activo inmobiliario, y las necesidades mensuales de cash-flow necesarias para ir costeando cada uno de los puntos que forma el total de la inversión.
Please update the team members' progress through Teams in real time. If you want to know the details, please contact us further. ※The wishes listed in the file attached can be changed. If there is a problem with construction, you can change it after consultation.
I want to connect data from Excel and Word and have it feed into ChatGPT automatically to create outcomes and run workstreams. Can someone create the API and connections? Open to other platform integrations with ChatGPT such as Slack etc. Welcome feedback and guidance. Thank you!
The project is as follows Move some cells from one row in some columns to the same column one and then delete rows of copied cells. Example Lookup column B value ”6949785206893” (Row #2) Result: column A “6949785206893” (Row #3) Copy Cells of columns E, F, H, P, Q, R, S, T, U, V, W, AU, AV (Row #3) Paste in Cells of columns E, F, H, P, Q, R, S, T, U, V, W, AU, AV (Row #2) Delete an entire row of Result: column A “6949785206893” (Row #3) Continue to next till the end of the sheet (could be up to 40,000 rows) Possible that other sheets need to be created to combine the proper data or to have the lookup values. Also, you may need to add sheets to copy-paste data
I have an excel report that consists of a small dataset (within the sheet called "Data") that populates a number of tables within the report. The tables are pretty basic and contain all the formulas in them. I would like the report moved into Power BI. I have already added the data to the pbix file so it's just a case of creating the measures and replicating the views from the excel version
PHP code to import excel sheet in database. Excel file format is fixed and we need to create a php code to import all data from excel sheet to mysql database using php core code file... 1) HTML Page to select excel file 2) upload script that will upload data from excel sheet to mysql database
we have some data on word document and want to transfer it to an excel sheet, we will provide the template and also we need some research done and find emails and add them as well
I am running a strategy on tradingview, and connected to Tradestation on tradingview. I need a script or something to open and close trades on Tradestation when alerts come through on tradingview.
...to pdf files ②Conversion to EXCEL BOM Table.(Drawing BOM Table into EXCEL BOM Tables) There are Mechanical Drawings Bill of Material [BOM] is in image format, which is to be converted into Excel sheet table format. Image file Inputs will be shared along with An Excel sheet Reference format. which is needed to convert the BOM image file data table into Excel file data format. Although this is a NON-TECHNICAL job but knowledge of the Excel tool is a must. Little Mechanical know-how might be an advantage, materials and all are present there so converting the original data into excel must remain the same. whatever means of conversion using internet tools or CAD tool is fine to me. 1 Image file and 1 Excel file are attached for you...
Tasks 1. Create a new form on the website using questions already shown on example. 2. I need the data that they fill out on the website to popular the cells on my excel (see example). 3. The form should automatically save a folder to our Google Drive or Dropbox (if preferred). It should be titled the customer’s name and should save their excel and uploaded files inside this folder. I already have this excel set to populate a Word Document (our quotation file), so I just need you to take the data from the website form and put in in my excel.
We do need a Formula or a macro for a data merge between 2 x Excel sheets by 1 x uniq attribute. 1. Excel sheets consist of 2 x rows (A; B). 2. Excel sheet consist of 1 x row (A) Values of row A from sheet 2 can be found into the row A from sheet 1. Corresponding values of row B must be copy into the sheet 2.