spreadsheet

First, I should point out I'm using Excel for Mac. So I've gone to File, Import, CSV file, selected the file and it has imported successfully on my spreadsheet. I've also got a Macro set up so every few seconds it checks for updates and refreshes the imported data. I'm trying to make it so if...

Hi all, first time poster here. Hoping someone can help. I've created 2 spreadsheets to use in a mock scenario for testing my department's flood response procedures. On the 1st spreadsheet (called Location), I've written a macro to constantly increase the value of the river levels every minute...

I have a reservations spreadsheet that I need to transfer data to to another sheet if a cell is not empty using an ActiveX button called TransferNoShows. I need the following to happen when I press the button: In Spreadsheet 1 If a cell in I3-I39 is not empty Transfer (append) Data in Cells...

Hi all, I am looking to be able to input a figure into a cell and when I press enter, have the cell automatically remove the vat @ 20% I know the calculation is to divide by 1.2, but thats as far as my knowledge takes me! Is there any code I could use to do this. I have a spreadsheet from work...

I am creating a userform that my sales people will use to generate a Purchase Order Request. The form will populate a spreadsheet that my inventory control department can use to track the status of requests. I want the "save" button that saves the userform and populates the data to the...

Hey folks, Suppose I create two queries for the two tables in my spreadsheet https://1drv.ms/x/s!AvjBsEPEq12ngTmYWfZW_bAjU4w7?e=9d2PBI Is it possible to somehow merge them as per my example?

Please can someone help with a script - if column 'O' = .29 then in column 'I' = H/60 if column 'O' does not = .29 then column 'I' = 'H' Then 'J' = 'I' * 'k' The spreadsheet is very long so it should work for all lines in the spreadsheet Thank you

Hi, I have a list of c4000 individuals records on a spreadsheet who all hold a qualification that has to be renewed every 3 years. I would like to find an easy way to send reminders directly from the spreadsheet to the individuals concerned with all the details they need to renew in an...

Hi everyone, Newbie question here so any help I get I'll be grateful! I tried using the following script to save a spreadsheet onto sharepoint which i've opened with vba on another spreadsheet. Path = "http://sharepoint.com/" filename1 = " Test File" dtt = Format(CStr(Now), "hhmm")...

I have the following Module that inserts a ticking clock, with the current time , on to a worksheet that is used to send automated emails once past a certain time. I also have a VBA Code that takes photos from my desktop and inserts them into the same spreadsheet based on the name of the saved...

Hi All, I have a spreadsheet and would like to know if it is possible if somebody selects "yes" from adrop menu options of "yes/no" that the row is atomatically copied from one sheet to another that is password protected? I want the first sheet to accumulate the workflow coming into my team but...

Hello I want to make a simple table that counts "Yes" and "NA" as a positive and gives me a percentage total. For example if I had a list of 10 cells and I had 8 Yes, 1 NA and 1 No I want it to give me a result of 90% I have played around with formulas and can get this =COUNTIF(A4:A13...

I have a savings account where interest is calculated daily and paid on the 3rd of each month. Most months the account is not touched but sometimes I might pay an amount in or take some out. Have created a spreadsheet with columns for amounts in/out, daily balance, number of days between...

Hi all I've created the this spreadsheet: https://www.dropbox.com/s/y9nykdyne8p04ku/Executive%20PA%20Diploma.xlsx?dl=0 but I need to stop cells relating to the same course from being split when I print the document. I was going to put additional rows between the courses but this...

I would like to be able to send email attachments from excel using VBA. I've got a macro that I use to generate PDFs of customer invoices from a spreadsheet and I'd like to add to the macro to open outlook, create an email, get the email address from the same spreadsheet and attach the invoice...

I have upgraded Excel to 2016 and now get an error when using an older file with a spreadsheet object embedded in a userform. I think Microsoft Office Web Components 11.0 may no longer be supported, but I wanted to find out if there is another solution for displaying data on a userform that...

Hi, in the code below I am trying to reference the column number within setColumnFilterCriteria from the named range AttendeeStatus so that this piece works no matter where this column is. Any ideas on how to do so? function FilterAttendees() { var spreadsheet = SpreadsheetApp.getActive()...

Hi, I need to calculate the standard deviation for 'Duration' data, based on 2 conditions in multiple columns that both need to be TRUE. I had some trouble but ended up using the DSTDEV command. I want to be able to avoid getting an error when there is no data that meets these conditions. I...

Hi everyone, I am new to VBA and this forum, so, please forgive me if I'm doing something work. I have been fairly successful with what I am trying to write in VBA, but right now I need some help. Basically, I've been trying to identify the cell number and row in a spreadsheet that matches a...

Hello all, I have the task of setting up an audit trail for all changes that are made to a spreadsheet. Suppose the spreadsheet has Sheet 1 and a log sheet. I want the log sheet to record all changes made to Sheet 1 by displaying the user name, the change, the old value, the new value, the...