Is there a code or formula I can put in place that will enter the Microsoft user's name or email, who is in the excel sheet, in column N when text is entered in column A?
Hi
I am creating a VB form, which updates a spreadsheet, and as part of this creates a unique reference number.
I want the Ref number to be CUST/YY/unique number
I am struggling to get the year automatically, I have tried a couple of ways but it didnt work. Currently I am using the below...
Please do you know how to formulate the following condition in excel; when you have two cells one with high and the other with low value and one of the cell is colored green. so you want to return a value of '1' if the lowest value amoung the two cell is green color and '0' is the highest value...
Objective: I want to export a known range of Cells to a .txt file with the click of a command button. I want the file to be automatically saved with the name as the value of a cell (A12)
I already did some research and was able to slightly change an existing code I found that someone created to...
Hi
I'm a complete newbie to VBA and struggling to find a google answer that fits my specific needs and lack of knowledge.
I have 2 workbooks; One called 'Master' that contains a unique code in column A and a long text description with bold, coloured text and colour shading (not conditional...
Hi,
I am trying to run something that will remove the entire row if a series of letters are present.
I am using the below code. It works, but I need to add in around another 25 letter combinations (i.e at the moment it removes EZY, but I also need to remove EX, EFT etc etc.)
Can anyone...
Hi there,
I am relatively new to both VBA and very new to SOAP. I have an online shop which I would like to be able to download orders from through excel.
I have been given the following SOAP code by the online shop but have no idea where i go now - i'm sure it's relatively simple but don't...
I'm a novice at VBA and am using the immediate window. I am getting a Run-Time error '1004': Application-defined or object-defined error and I don't know why. I have the following code in my immediate window.
I have a similar code, but for the Income Statement which works just fine. I...
Hi Gurus, :-D
This is my first post so if I'm not playing by the rules, I'm happy to take on any feedback...
So I have a code that I use frequently that I want to place in my "personal macro workbook" so I can call it quickly without re-writing it each time I wish to use it. The code...
Hello Everyone,
I'm sort've new to Excel and writing code in VBA. I have the following situation: my company tries to make revenue predictions at its many sites (740 sites). We are the midst of creating a forecast method and we'd like to compare the old one to the new one. So currently I have a...
I have a series of swipe card "beeps" in excel 2010 for the month of april. They are sorted by date per each employee. There are multiple "beeps" per day since the employees go from the production floor to the cafeteria, home, or to the restroom
I need to device a macro where I can calculate...
Hi
I'm trying to add a date picker to a sheet that will run when a user selects a cell in column A. I got as far as being able to run it any where on my workbook but I am having problems containing it to column A nor can I figure out how to make the date picker appear when I select a cell in...
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.