spreadsheet

  1. M

    Autofilter omitting some columns and I can't work out why

    There are headers in the top row for all columns. There are no gaps between columns. Columns A, B and C are frozen. I put autofilter on and it's fine. Then sometimes after I have been merrily using the spreadsheet for a while I notice that columns A and B are not in the filter. This is...
  2. C

    Employee Attendance Tracking with Points - help with SUMIF Formula

    I am working on an employee attendance spreadsheet that is based on a point system. Point values are associated with different absence reasons and tracked on a rolling 12-month calendar. I was able to successfully complete a spreadsheet to take care of this part. However, I am unable to figure...
  3. M

    Data Validation

    Is there a way to do data validation to prevent text entry in a cell without using a macro? We also want to be able to copy data into the spreadsheet with the data validation.
  4. S

    Sorting spreadsheet by time

    Hi I have a spreadsheet that contains among other columns, 2 columns. They are start time and end time. Their format is 7/1/2019 2:17:11 AM for example. Of all the start times, I want to ONLY retain the information where the start time is */*/2019 21:00:00 PM and the end time is */*/2019...
  5. E

    Coverting layout of spreadsheet

    Hi there, I am completely new to excel and I was unaware of the extent of its functions. I have been tasked with converting the layout of a cinema timetable that is in a spreadsheet. the timetable also includes the age rating of the movie and the director . I am also not going to include certain...
  6. C

    Co Authoring

    Hi, Hoping someone can help please, Does co-authoring in excel online (document is stored in office one drive) support cell protection? Id like different users to have specific access to parts of the spreadsheet. But from what I can see this feature doesn't seem to work when editing the...
  7. D

    Vlookup if formula needed

    Hi I am looking for a formula that can vlookup based on multiple criteria. I need a formula for F4 (on spreadsheet 1) that will look up the value of column F (on spreadsheet 2) if column E (on spreadsheet 2) equals "Claro" and Column A equals the site number in A4 (on spreadsheet 1) and column D...
  8. D

    VLOOKUP and COUNTIFS ?

    Hello everyone, Here is my problem, I have the following spreadsheet: <tbody> A B C NC 1 Name 01/01/19 01/02/19 12/31/19 2 Franck F IC O 3 Larry O O F 500 Patricia F F IC </tbody> The data in it has to be used in another spreadsheet which looks like...
  9. G

    Vba to match 2 tables and count the number of occurances

    Hi, Can someone help me with the vba for the following- I have 2 tables in different spreadsheets, which have a common field -policy no. The main table is in spreadsheet 1 and the other in spreadsheet 2. What is required is to find the number of times a policy no repeats itself in the second...
  10. D

    Searching in Excel crashing/Flickers

    Hello, this has been an on-going issue but now it's getting out of hand. My excel crashes, I can't close it from the taskbar nor can I CTRL, ALT & DEL, so have to power down. Usually I've got 6-7 spreadsheets open working on a 3 screen setup. Since last night, I tried a few different ways...
  11. H

    Sumifs/Macro

    I posted on here before regarding a sumifs formula and I appreciate the help that I received. Now I am finding out that it is not picking up all the data that I need and my boss wants to make this into a macro after I figure out how to make the formula work since this formula is so cumbersome. I...
  12. R

    Editing imported data

    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...
  13. C

    Updating values between 2 different spreadsheets by 2 different users

    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...
  14. T

    VBA Move Data to different Worksheet if specific cell not empty

    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...
  15. A

    Removing vat from a cell automatically

    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...
  16. P

    Opening new email from command button

    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...
  17. danhendo888

    Is this merge possible in PQ?

    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?
  18. M

    Calculations based on criteria in another cell

    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
  19. R

    30/60/90 days reminders emailed from excel

    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...
  20. C

    Occasional error with saving macro on sharepoint

    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")...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top