store

Hi! Question.. I have got store list on B3:B7, dates when the vehicle changes for the store on D3:D7, vehicle registrations drop down list on F3:F7 and when the next change is due required on H3:H7.. now what I want to do is if the same vehicle is used for the same store 4 days in a row to be...

Dear all, I am looking for the code to compare the each values in an array and an active excel sheet. 1. I have already an array 2. Compare the values in the array to a active excel sheet, if value is found store it in a New Array2 3. If no found then store it in another array 3. Once this...

Hi, I am prompting users to enter a password when they click a button that runs a macro hiding and formatting cells. Dim Password As String Password = InputBox("Please enter password below", "Password", "????") If Password <> "2154" Then MsgBox "Incorrect Password"...

Hi i am new to VBA I am looking for the logic and code to comapre a value from array frommone sheet to another and if match found store it in one list box and if match is not found store it in another list box

Hi there, To simplify, I have 4 stores and I want to return the store name with the highest sales*. But I want to exclude store names with a numbered suffix (i.e. only store names that end with a letter suffix should be included). So in the table below, I'd want the formula to return Store C...

Hi All: I have a store performance report with about 120 rows of data spread across about 40 columns. I use t Drop Down list to select the specific store I want to look at (there's 80 stores). The report relies on several WHATIFS to select the right data for the right store, and it works...

Hi, VLookup is probably not the right starting point, but it's the best way I can describe what I'm trying to do. <tbody> Store Y/N Sales Formula 1 Best Buy No 4 No Target Yes 5 Yes Target No 3 Yes Best Buy No 9 No </tbody> Formula 1: Search for any "Yes" entries in column B, if...

I'm needing help with the Conditional Formatting - 3 Circle Icons. I am trying to get it to work based off a formula. Such if cell B2 is >= cell B3 it will be the green circle in cell B2. If it's 85%-100% it will be the yellow, or less than 85% it will be red. <tbody> Store Actual Plan 1...

Hi I have a pivot table with store data , there are over 300 . What would like to do is select multiple stores , I know i can do this by sellecting multple from the dropdown list , But as there are over 300 it takes ages to look down the list to find the ones i am interested in. Is there a way...

i'm very new to vba and i was wondering if someone can help out! i'm trying to have if statement go through each row if condition meets, store the other column value in array so i can retrieve the values later on. <tbody> 1 red yellow blue 3 red orange purple 5 yellow blue orange...

Hi All: I have the following formula that is working on all 1800 lines of my spreadsheet, except for 11 lines (266-276). On these lines I get a #DIV/0! error. =IF($D272="Store...

Hello! I've got a little issue here. I am pasting data from a sheet into another sheet to order it there: Sub Workbook_Open() Application.ScreenUpdating = False Worksheets("OrdLoj").Range("A9:C140").Copy Worksheets("preplj").Range("A1").PasteSpecial Paste:=xlPasteValues...

Hi All, Need some help here. I have a spreadsheet that contains a summary tab and multiple sheets with the data. On the Summary I am trying to obtain the following information. The peak utilization per month per store. ON the data tab I have the IN and Out peak utilization for each month in a...

Hello, I need to complete the table but I'm not sure how to write the formula in this case. Could you please advise. Chart A: original data <tbody> Project Product Store 1973 A Store1 1973 B Store2 1973 A Store1 1973 C Store3 1973 A Store1 2233 A Store1...

I have a big sheet of lots of data that I want to peel some info out of. In my DATA sheet my columns are as such: A1 B1 C1 D1 E1 F1 G1 H1 Store Model Name IP Pub Port 1 Port 2 Net...

Data Table: <tbody> Date Store Agent July 1 2017 Anderson 100 July 1 2017 Nashville 99 July 1 2017 Kentucky 100 July 2 2017 Maine 100 July 2 2017 Riverdale 99 July 4 2017 Alabama 100 July 4 2017 South Carolina 100 July 4 2017 Anderson 99 </tbody> Result: <tbody> Agent...

I have an occurrence matrix made from a set of sample data. The data represents a series of stores, and a series of items held at each store. There are over 6000 unique store locations, and around 400 unique items. The occurrence matrix maps whether the item is at the store. In the sample...

I have a spreadsheet that will auto send an email, attaching the current spreadsheet after the user is asked to save the document. The email works fine with everything hardcoded. I even included email addresses on another spreadsheet on a server that this WB points to so the To and CC are always...