I have built a sheet that helps me manage my inventory. I have a BIN REPORT and REC INPUT tab where i update information which then feeds to my CONSOLIDATION tab which helps me minimize warehouse space. I even...
Hi Power Users!
I am very new to Power Query, but an advanced Excel user. I am starting to get into Power Query and using data tables across a number of workbooks.
I have a column in my data table that should be a number however, sometimes it will be a text due to a letter being added to the...
I have macro in VBA that uses a data set in excel. Then it filters all but one specific vendor. Everyone else is removed from that data set. Unfilter. Then I'm left with headers only and no data lines (line 2 and below) or I'm left with header data and data in lines 2 and usually more.
I have TextBox1 in a userform. When somebody opens up the userform the textbox is prepopulated with a number already in it (.31), however I did leave the option for the user to change this number if needed. The reason why there's a decimal because when the number is submitted on...
I would like to firstly check if a specific sheet exists, then if TRUE, extract a value from that sheet.
I do this in two stages:
Step1:- Cell B3 - If sheet "JAN2018" exist, then return 0, else FALSE -
Step 2:- Cell B5 - If cell B3 = 0...
I am failing dramatically at writing the code for this, what I thought would be a simple macro.
This initial process is the following:
IF E2 begins with “006***” THEN return the last 8 characters in the string in U2, only IF the final 8 characters are numbers, THEN return “N/A” in U2, & IF...
I am using open office calc (apache) and in my document
I have a number of dropdown lists e.g dropdown list 1 has the following entries:
In another worksheet of the same document I ask various questions (say to some sales people) e.g
(in cell A6):
Q1) Would you like...
Hello dear Excel users,
I wrote a macro that is creating 3 pivot tables, all in separate sheets, from the same table (table1) in the sheet RAWDATA.
The last pivot table must be created only when at least 1 row in table1 in column K is containing the word TRUCK.
If no rows exist with the word...
I am trying to conditionally format a cell based on other
conditional formatting in a range of cells.
I would like cell E3 to be:
Red if any cells (O3, T3, Y3, AD3, AI3, AN3, AS3) are Red
IF NOT THEN
Yellow if any cells (O3, T3, Y3, AD3, AI3, AN3, AS3) are Yellow
IF NOT THEN
Green if any...
Hi all. I have a dilemma I hope you can help me with. I am not great at VBA so bare with me. I need a macro that will look in an individual cell and work out what to do with its contents. There could be a number, or a text and a number. the column is essentially serial numbers. for eg.
I am trying to correct an error on many spreadsheets (100+) we have located out on a network drive. I had a formula that was incorrectly written and needs to be updated. I've written the code below to be used in a loop macro that opens up each spreadsheet and updates the formulas (if...
Please help or advise. I am trying to write an IF statement that allow me to autofilter my data list. My code is to use string function to detect a certain text in a cell (D3), so basically if D3 contains "77" then filter with a condition, else filter with another condition. Below is how my...
I'm brand new to VBA, and I think I've exhausted my efforts in trying to figure out my problem. Our VBA expert left the company, and I was tasked with optimizing a tool that he created which we use to send email correspondences to candidates. The code works as is, but my manager...
I would like to run the below code only when there is no "x"'s in the following ranges:
Dim iRet As Integer
Dim strPrompt As String
Dim strTitle As String
Dim num As Integer
Dim var2 As String
var2 = "x"...
I would like to apply the following code (only if the shape is not already placed in the location):
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Sheets("Pricing").Shapes.AddTextBox(msoTextOrientationHorizontal, 807.3529133858, _
I am relatively new to VBA with basic knowledge and need help writing a macro..
I have text in column V of my worksheet, the value of cells in column V is either "Clear", "Pending" or blank "".
I want to write a macro that will input the date the current date into columns U and W IF the...
I need cell V3 to populate with a percentage that corresponds with a range of cells (AC7:AF9 shown below) based on a couple of variables (their age, whether they are male or female). basically it should be like this...
Cell V3 (A Soldiers Allowed BF%) will automatically populate from a range...
I have a problem with declaring a variable which I want to use later in my macro. The problem is that I need to first "calculate" this variable which is dependent on the file name.
I used "if then else" statement to pull out from the file name one thing that changes - week number. The...
I need to modify a complex array formula.
Here's the logic....
if the value in column A matches with the value of column A in previous row;
if the value in Column E has occurred for the 1st time for similar value of column A