excel2010

  1. S

    Excel2010 VBA for reminder Outlook2016 emails, three months before review date

    Hallo, I'm an admin and VBA newbie, trying to send automated reminder emails from Excel 2010 via Outlook, three months before the review date (in Column C). I've managed to send an email from Excel :) But can't get any further, have tried the YouTube videos but am baffled and was advised to try...
  2. B

    Transform comma separated ID's into comma separated Names in Excel 2007/10 using lookup table

    I'm trying to match comma separated ID Data to the LOOKUP table and return the NAMEs of the IDs also as comma separated. The last column shows what the required output should look like, and the Current Formula Name Output is the results I have from my formula, which is working correctly. -...
  3. W

    How to make a user defined table style available in all Excel workbooks

    I have a medical vision issue because of which I am able to only use a dark background. Sometimes I get Microsoft Excel workbooks which are designed to be viewed on a light background. In those cases, I have to change the colours usually using the table style feature available in Microsoft...
  4. W

    Is there any way to highlight the first two rows automatically after applying filters in a worksheet?

    is there any way that I can coloured the first two rows in a worksheet automatically after applying the filters?This is the overall problem :I have got a sheet with columns like thisitem price criteria1 criteria2I have to frequently filter and note down the price of the first two rows of the...
  5. M

    Help export a table content to txt file using a vba

    Hi all, I would say from the very beginning that I am not an expert in the VBA code... that's why I come with the request to help me with an answer to a problem So my problem is: 1. I want to export a table to a text file...till now is simple (I also give a google search after a vba code model)...
  6. N

    Formatting numbers in a userform textbox

    I have the following code behind a textbox. I expect it to complain if the number enter is greater than 999.99, yet I can add 345566 and it gets accepted. What am I missing? Private Sub EntryBox12_AfterUpdate() 'Start Mile Marker If EntryBox12.value <> "" Then With EntryBox12 If...
  7. R

    Excel VBA master sheet copy-paste error 1004

    Hello, I am new to VBA formulas in excel. I have a workbook with multiple sheets which needs to be copied(only values) in a master sheet in the same workbook. The problem is i get an error on one of my sheets: "Runtime error 1004 : The information cannot be pasted because the Copy area and...
  8. M

    Pick number of random cells in range and change value with VBA

    Hi everyone, I have an Excel sheet which is used for testing. Starting in F5 to HZ5 (so that row) cells are filled with the value "Yes" or "No". Depending on this value, the testcase is tested or not. I want a function to put a number of random testcases to yes, and the rest to no. Keep in mind...
  9. W

    How to autosize default Excel 2010 workbook on opening

    I am using Excel 2010 and have created a new default workbook, Book.xlts, and saved it in the XLSTART folder. A Ctrl-N will create a new workbook in the open Excel window based on this default workbook, but it retains its original size. I would like this window to open as the standard...
  10. S

    DynamicLastRow

    Hello, I've been searching a lot but can't find the answer. There are a number of cells with text string "DATE" in column "A". Under every "DATE" there are 0-5 rows with dates, followed by an empty row. I want to copy the "DATE"-row and the following rows with dates (0-5), offset 11 columns, to...
  11. T

    Debugging formulae in Excel

    Is there any facility in Excel (I'm using Excel2010), whereby you can look at part of a complex formula, and immediately see what value that part equates to? Regards, TS
  12. C

    Sheet to Template Sheet

    Anyway to get the spreadsheet created in the code below to be the same as a template Sheet I separately created? Code: Dim sh As Worksheet Set sh = Sheets.Add sh.Name = AddEmployeeUF.txtFirstname.Text + AddEmployeeUF.txtMiddleinitial.Text + AddEmployeeUF.txtLastname.Text +...
  13. N

    [Excel 2010] Formatting calender depending on list of dates

    <tbody> dates M T W T F S S 01/27/2017 16 17 18 19 20 21 22 01/28/2017 23 24 25 26 27 28 29 01/29/2017 30 31 1 2 3 4 5 02/02/2017 6 7 8 9 10 11 12 </tbody> Hey! All I want to do is to highlight every day in the primitive calendar on the right that is stored on the left in the...
  14. I

    Can VBA or cell references be used to pass parameters to Power Query

    Hi everyone, Can VBA be used to "control" Power Query, or can there be dynamic query parameters? I'm relatively new to Power Query (in fact, still using Excel 2010 version). For example, if I have a standard SQL query that would need to be updated for different users, can I parameterize it...
  15. S

    VBA Send and Save

    Can anyone help me?? Please look at the code below vba coding I have used on a work spreadsheet. First lot of coding Is the main coding I want rectified however I'm struggling with the automated save bit, and I do not want it too be a temporary copy that is deleted. I want the code to ensure...
  16. H

    RE: Office Tenant - Rental Status Sheet

    RE: Office Tenant - Rental Status Sheet Hi I am looking to create a worksheet which works out how much rent is still outstanding for a particular client in an office building. The worksheet should act as a statement of account / rent ledger showing the client the dates they were invoiced,the...
  17. D

    Excel 2010 - Auto populate cells

    below is sheet No1 & 2: Sheet 2: i would like to Automate excel so that it takes the inspection number from Sheet 1 (yellow cells) and put it in the appropriate location in sheet 2 (Red Cells). For example: 1st yellow cell in sheet 1 is "Floor paint" in the "Entrance". now it...
  18. S

    How to extract & paste the filename into another workbook?

    Hello, I'm having a problem with extracting and paste the filename into another workbook. I have code for: Copy Cell "R19" in "Sheet1", in every workbook in folder "Test3". Paste that value into workbook: "vikt.xlsm", column "W" with: Workbooks("vikt.xlsm").Worksheets("Sheet1").Range("W" &...
  19. J

    Edit Cell Contents using SendKeys?

    Good morning - I have a column of data containing dates that are entered as mm-ddd-yy. I have attempted to convert the format to mm/dd/yyy, but it appears the cell contents are being treated as text, and won't convert properly because Excel doesn't know if the year should be 19XX or 20XX...
  20. A

    matching entries in two columns and retaining corresponding observations only

    Hello, I have excel sheet containing around 100K observations (rows). There is one column say "A" containing some IDs and each ID is having 10 parameter values (say in columns "B" to "K"). Now, I have another column say "AA" containing IDs (around 1K) which I'm interested in filtering from...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top