excel2010

I have a folder filled with a lot of excel folders that are all formatted slightly differently. I have to find the "part number" in each and copy and paste the value that's next to them into a new excel sheet. Part number also needs to be case insensitive because sometimes it's all caps, just...

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

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.

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.

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

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

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

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

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

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

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

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

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

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

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

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

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 +...

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

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

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