excel2010

  1. R

    Macro: Copy entire column into new sheets based on criteria listed in range in another sheet AND also first 4 columns copied onto new sheet

    Original Post here: Macro: Copy entire column into new sheets based on criteria listed in range in another sheet (excel 2010) | MrExcel Message Board Macro should execute on command. I realized I also need all rows for the description columns (Desc 1 to 4 are Columns A to D) to get returned...
  2. T

    How to create pie chart from 1 column with duplicates

    Could someone please help me. I'm trying to create a pie chart from only one column which has duplicates, I want it to display the name of the item and how many duplicates there are of it. Se below Apple Mac Windows Apple Mac Apple Mac Please help.
  3. T

    How to get month and year from date

    Could someone please help me. I have a 2 columns one with a date and I want to put the month of the date in the other, see below 11/01/2020 I want the month and year of the date here ie. Jan 2020 12/02/2020 ie. Feb 2020 13/03/2020 Ie. Mar 2020 14/04/2020 ie. April 2020 Please help.
  4. G

    CountIFs number of entries which match two different variables between two dates

    Hi all, I am looking to be able to count the number of entries between two dates which match two different variables. In the example attached, I want a formula which will count the entry if it contains the relevant product AND Name of sales person. My code at the moment is...
  5. 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...
  6. BradleyS

    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. -...
  7. 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...
  8. 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...
  9. 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)...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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
  16. 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 +...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top