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
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
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
...Template (The format how it should be is attached) Which shall include the followings; 1) It should have Vendor Form to create Vendor and enter their details. (This should be saved at the back end) 2) It should have Item Register to create new items 3) Purchase Order (PO) need to be generated (in a specific format). The PO number should be auto generated
There are 2 excel files: [kirjaudu nähdäksesi URL:n]: - contains information about the contacts that belong to some company - contains information on what kind of present was sent to this contact for the Christmas throughout multiple years (types of presents: card, eCard, calendar, other (+comment field)) - contains also deactivated contact – i.e. was a contact
We have a php file that is used for translation. We need to pull out the text to be translated so we can import it into a translator more easily. For example, in the first line, the is: 'Jobs ads in the World' => 'Jobs ads in the World', and we need a table that just says: Jobs ads in the world There are 800 lines, so you'll want to come up with a clever way to do t...
Objective: The objective of this project is to create a professional Financial projections Excel sheet model/template for the entities: - Company X Holding B.V. (parent Holding) - Company X international B.V. (subsidiary) - Company X B.V. (production company) - Newco 1 B.V. (intermediate holding -> Blockchain product) - Newco 2 B.V. (intermediate
We need email addresses, Company name, address, and telephone numbers copied and pasted from company directories (website addresses to be supplied) into an Excel sheet (pre-formatted). Approximately 3000 companies (or line entries) are required. Occasionally a company does not have an email address listed. We require the data entry person to then attempt
In this spreadsheet you will find approx. 100 Finnish companies. The information we are looking for is the sales people's contact informations. So your task is to browse through these companies and find answers to these questions: 1) Who is the sales manager? 2) What are his/hers email and phone number? 3) If you can't find the manager's informati...
...are updated regularly. The following VBA Script functions when located on the same WS (see WS CA Macro). As an example of what I was think I will poorly rewrite it. It doesn't need to be that exactly, whatever you think is best that accomplishes my needs. It must always remain in the row even when resorted. VBA that function when on the same WS. Sub
I need a Excel based Visual Basic code written to get the data into Excel. I'd like the ability to enter a stock symbol in a cell (like DUK or CSCO) and have VBA pull back all the option data available. The two websites that have the easiest and most complete data are: [kirjaudu nähdäksesi URL:n] (multiple
I need two membership lists of two associations scrapped from two websites into excel sheets listing individual members, their names, emails etc. Estimate is of 500-750 members in total. Approx 15-30 seconds per member. There are several fields I need copied that can be copied and pasted such as name, business name, phone, email etc. The search field
I need a script that will take a bar code in excel , go to a website that has a search box, paste the bar code into the search box then copy the image link that it produces and insert that image it into a cell in an excel in a certain position.
Hello! I would like a scanned document of contact details transcribed into an Excel spreadsheet. It consists of about 625 rows and 10 columns (company, contact, phone, title, address, etc.). Attached is a jpg showing what one page looks like. Regards.
On this website, there is a map with 182 clinics. I need data for each of those clinics put into an excel spreadsheet. The deliverable is an excel spreadsheet with the following information for each clinic: Name, Website, City, State, and Type. Data must be 100% accurate. I have uploaded a sample with all of the clinics for the state of Utah. Thanks
...knowledge transfer (explain work done and transfer knowledge). I need an expert in VBA/MS. Access/MS. EXCEL to develop a database management system (update records, delete records, add records, view historical deleted records, etc.) Via a graphic interface (MS Access or Excel). Document to generate preset analytics and graphic reports. Document to have multiple
...for an Excel data entry expert that can help us to reformat pricing files into a suitable format for our online shop. We need the product name, material, measurements, category, price and picture from the manufacturer's price list reformatted with all entries in one single line. Right now the information is in different lines of the excel pricing
Need to convert documents using PHP 1: Word to PDF 2: Excel to PDF 3: PDF to Word Need East Europe(Ukraine, Serbia, Belarus and so on) Thanks.
Hi All, We are looking for a Grafic designer who can edit the photos which we will provide for our Instagram and Facebook Page. We are looking for someone who has already worked at similar jobs, has good English skills and knows how to edit photos on Photoshop or equal tools. Our Instagram Page is: _collegescouting_
Need to write a macro which will convert html text to cell in excel and format it. For e.g., <p>An unordered list:</p> <ul> <li><B>Coffee</B></li> <li><U>Tea</U></li> <li>Milk</li> </ul> Will display as An unordered list: • Coffee • Tea • Milk" This is just an example ...
I have 88 individual PDFs, and I want the data pulled from two lines of the documents and put into a single Excel spreadsheet with headers. I've attached one of those PDFs. I just want the data from lines 17.1 and 17.2 put into the spreadsheet. all 88 have identical column headers.
i want account dashboard in ms excel sheet , other data entry sheet and dashboard result data manege in other sheet table as well.
...into a spreadsheet. I am looking for someone who is very methodical, can work fast and efficiently and is experienced with MS Excel. I will provide the list of websites from which I need the information and also the Excel spreadsheet with tables set up ready for data entry. You just need to go through each website and collect the data to then enter