I have two sheets (Pre and Post). I want to copy value of a row if it equals certain value. To be specific: if cell J1 in Pre Sheet is equal to any cell in the Column Q in Post Sheet, then copy the value in Colum P in Post to cell K1. I am available for further explanation at anytime.
I have a spreadsheet in excel that includes a macro simple (less than 50 lines of code) It mainly just moves stuff around I have recreated the spreadsheet in google sheets [login to view URL] but I can’t recreate the macro as I don’t know google apps script. Is this
Hiya, I'm gonig to make an attempt at trying to gauge h...gonig to make an attempt at trying to gauge how expensive various projects is done by freelance artists. for example what the commission would be for a blobby jell-o kind of cell would be all the way to how much it would cost for an animated 3D face, say a few seconds of 'footage'/'rendering'.
I need an electrical socket that can be turned on/off remotely using a cellphone. The socket would allow a sim card to be inserted. The plug must designed for US/Canada standards (not UK/EU/Australia).
I have a column containing around 8000 of values The column describes a volume of alcohol bottle. The job is to parse the column and reduce to new columns: 1. Clean volume 2. is no. of bottles >1 For the cleaning regex there are several rules but it easier to show an example of the first 100 values, I attached an example of the parsing in the attached
Would like some items updated and changed on my current website for my small cell phone repair business. Website is [login to view URL] Items I want updated are photos on main screen of repairs being done in background. I want those removed and the page simplified. I want photos of each iphone model i fix with prices next to it in rows of 2-3 in the
...have 5 columns, all sortable except second column for it would be to open row details. Each row details row should display several client-side customizable data sets (link, banners, banners embed code) extracted from MySQL database with the same ID as column 1 ID on it's own MySQL database table and column. Initial table should be loaded separately
Update the sign-up fields of a member press page to be two column instead of single column.
I'm a poker player ...grids vs positions. There is a video attached that shows the idea exactly. The grid size on each sheet will vary, but each cell of the grids will link to pictures of ranges across the grids bet sizes. At the bottom of the excel video you'll see there are 6 sheets with the same macros on each. All the information will be provided.
...where whenever I copy my urls into a google sheet the links have hyperlinks automatic. I can remove then in Excel easily, but as soon as I paste them they become hyperlinks. How do I stop that in just the 1 column from happening? Also I need 2 blank rows every 5 rows. need to work on this now, anyone available? Can be done in Excel or google sheet
I need some help with API connectivity to 3 cryptocurrency exchanges. The following functionality in excel VBA needs to be created: 1. Get live price data (bid, ask, sizes of bid and ask) for selected crypto currencies - including depth of the market 2. Live price data collection and archivation. 3. Ability to access archived data. 4. Get cash
Hello, I require an excel expert to work on an existing excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynamic. It needs to map the values
php script which reads from a text file example [login to view URL] ( contains example 1234 ) write to cell a1 of a google sheet php version ============= my $service = Net::Google::Spreadsheets->new( username => 'mygoogleaccount@[login to view URL]', password => 'mypassword' ); my @spreadsheets = $service->spreadsheets(); # find a spreadsheet by k...
I have an old workbook - xlsx format - that I forgot the password and need to unlock. Since its newer than Excel 2007 its encrypted and the old style VBA password buster wont work. To confirm you have unlocked the workbook show me "Period 1" sheet
I need vba that will autofill and autoclick through the creation of a Salesforce opportunity. You don't need to know anything about Salesforce. Take csv data in worksheet and fill fields, click buttons to move to next screen, etc..
...Greenland We are looking for testers from Greenland for one very interesting and extremely easy project. Our customer has servers all over the globe, which only passively gathers cell signal strength info and now he wants to add one more in Greenland. Therefore, as part of the project, we will send you a server which you have to set up in your home on your
I have an Excel tracker file from which two dashboards and graphs are to be generated. The tracker gets updated regularly. The dashboards and graphs are to be updated automatically. Time line to complete task would be 2 days. More details will be shared with short listed freelancers.
Hello, i am looking for someone who can scrape the DHL parcel information with MS Excel vba. The tracking number is given (Column A) and the tracking information (Column C:L) should be scraped from DHL page (Link in Column B) This should regulary be done for up to 50 tracking ids.
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
...I need demo ro using userform in outlook use to set appoitment step 1 : build this simple demo userform in outlook step 2 : set appoitment based cretiria the vba code should look for appointments in the calendar in date 14.11.2018 in this exemple if from example there is appointment in this data from 10-13 then
i would like a single php script which would update the cell a1 with a value i can specify in the script. [login to view URL]
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned.
...ABC 1-Nov-2018 24 ABC 5-Nov-2018 36 XYZ 12-Aug-2018 32 etc We want a macro VBA Program that can take this data and do the following: 1. Summarise to monthly level by product Store as a new sheet. 2. Apply the Excel Forecast Function to the monthly data for each product and output in the following format for the next 12
Necesito un código en VBA que extraiga la data que está en la siguiente web: [login to view URL]:9d16c843bb5201b86696ba79f964adbf/stock/AAPL/financials y la coloque en una hoja llamada DATA. Adjunto el archivo excel donde debe realizarse el codigo. ---------------------------------------------
I need to Rebrand my Company so that it is attractive to franchises and customers, I need a Logo which will get me great brand recognition, Aesthetic design, and industry-specific. So It’s time to give the CellFixx brand a facelift - we want an updated look-n-feel in keeping with the progressive, innovative mobile repair service that we are becoming.
I need to extract only the dimensions (like 12 x 24 x 36 inch) from our product description column in our product csv file, and have the dimensions put in a separate column. I am hoping I can get this done for $200. There are roughly 2,500 product in the csv file. I think this could be done with a script or something instead of manually, but I do
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
Try to code in VBA but it's not working. Trying to select on range of 2 original columns and match a new column and replace it with one of the original columns.
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
Manufacturing business wants to take a daily download excel file from GE Appliance website and create a Macro/VBA tool for non-excel users. The tool would look up our internal part number and box count from a table and output a pick sheet for shipping with customer part number, our part number and number of boxes. Should be able to select time range
...couple/few hours of design help: I have a set up a simple online store for selling domain names, using Wordpress and Wordperfect. I'm experienced in other platforms (sql/vb/vba, etc) but novice with web design. The site is basically two pages: The "Front page" with links and product list, and the woocommerce cart/checkout page(s). - I'm very open