I need two functions, ExcelXMLSpreadsheetToVbArray(strstrExcelXML,arrVB) and VbArrayToExcelXMLSpreadsheet(arrVB) pseudocode: Function ExcelXMLSpreadsheetToVbArray(strstrExcelXML,arrVB) .... Redim arrVB(intRowCount,intCellCount) .... ....Fill array with Text from Row,Cell End Function Function VbArrayToExcelXMLSpreadsheet(arrVB) Dim strXML strXML="<?xml version="...
Goal is to create a google sheet and custom report that joins data from 2 google sheets. Each month need to verify the work hours/ot/allowances for employees. There are 2 sources of data google sheets (WorkLog & Justlogin Log). The goal is to review help automate a process we carry out every 23rd of the month. Step 1: Generate Monthly Labor Report
1 small Program in Vbscript that Append a txt or csv file, into a SQLite Database table. Records are already sorted by Date. 2nd Program that access a table with HTML/VBScript (or Java) display records details by User, Device and a Dashboard with totals x month. A 3rd Program HTML/VbScript that appends new records on screen to a different Table
Opening a Used record store, need to look up value of record and enter into spread sheet to load into program (quick books) 10,000 records.
We are a wholesale distributor of products with a fairly simple Excel Spreadsheet and some simple macros to make it more user friendly. Basically, it's a tool where the order-taker can add a customer to the queue which is displayed on a TV in the warehouse. Then, a warehouse associate assigns themselves to the order. When complete, the warehouse
For this sheet [url removed, login to view] sheet [url removed, login to view] I would like you to go through all tabs as long as the name is not macro and copy all and then paste the values over it so it is no longer a formula
Cautam un expert in Google Sheets care sa ne ajute sa imbunatatim programul de monitorizare a activitatii agentilor de vanzari. Ce trebuie facut? Din programul de CRM cu care colaboram vom sincroniza un numar de raporate cu Google Sheets(un domcument pentru fiecare raport). Din acest raport vrem sa prelucram date in functie de agenti, data, criteriu
...automatic spreadsheet in excel for the management of a small society, I need to convert a pdf based document in a xls . As first step, is sufficient to copy exactly the pdf content ( including formats, tables, texts and values ) : no formulas are requested in the excel file. The expected result will be an excel file with 20 sheets identical ( or very similar
I want to make automated (auto-generated) invoice from google sheets clients database. Clients data will be inserted in google sheets thru online form wich will include: 1) information about clients (address, phone number, email address, ect); 2) products ordered, in ten or more drop-down fields; 3) discount proposed.
I have in Google sheets data, which are changing every day. I need to save rows of this sheet permanetly in other list, so I can use these information following days. And if code in column A is the same, as saved colum with this code at list with database, this row with this code is updatet to new line from current date. I need to save first 7 columns
I'm working on a research project, and desperately need help to summarize some data. I have data on 120 people (education, skills, job title etc) I need to pivot the data to show the most popular skills, job titles etc)
...script that imports the data from a specific email address when received and moves it to the google sheets 2. a macro that filters out everything except things that trigger a few conditions this will involve separating the data into the proper sheets 3. it then moves the target data to a google sheet which only keeps the data until someone flags
...talented individual who can design my logo could also complete the 3 data sheets I need (laid out) and made to look amazing. The business is a property investment business. We use investors money and buy properties for them and they get a high return. The three data sheets I want laid out are: 1. An existing property we have completed and own
Create a WebApp with: - a Log In page - a Main page with a entry form - a Product sheet with 3 expandable boxes (1 with two embedded fields; 1 with some numeric fields; 1 box embedded from a different webservice)