stores

I posted this problem a couple months before and I thought I had it figured out but now I have a new problem. I recently upgraded my computer to Windows 10 so now I have Microsoft Office 365. In my wishlist sheet some of my items are blank when I know I have them listed in my stores sheet. For...

Hi Goodmorning, hope you can help me please with some VBA code please, I have a userform called ‘Userform6’, andin this I have a dropdown box which is named ‘ComboBox1’ which has a list ofwords for example, Stores, Late start, Sickness etc. Then I have another comboboxcalled ‘ComboBox2’ which...

I have an Excel workbook that has a sheet that has a list of 500 stores numbered Store number 1, store number 7 store number 11, etc.. - these are my test stores. The store number is in column A. I'm calling this sheet "500 Test Stores". The sheet doesn't contain duplicate store numbers, it is...

Hello all! I have the following problem. I have CSAT (customer satisfaction) table, that compiles stores, months and their metric for each month. Stores are in the row field, months are columns. I would like to sort, for each month, the bottom 4 (at the top) based on their CSAT score. The...

I have this which I am using to track changes to a range; Dim xrng As Range Set xrng = Range("A2:N16") If Not Application.Intersect(xrng, Range(Target.Address)) _ Is Nothing Then Set ws = Sheet1 iRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row...

Hi, I need your help. I have to recalculate the amount of stores and mouths, but without a tool is impossible for me. The 2 immutable parameters (in blue) are: . Sales per Store per Year . The total month for all stores Thanks. <gs id="00bee639-f728-4141-b16d-d6d5324a091b"...

I am looking to build a dynamic set of formulas that summarize Monthly and YTD information without having to update the formulas. For example, say I own a portfolio with several stores in the retail, food and services respectively industries and have a database that breakout daily sales for each...

Hi, Hope you can help, I've spent hours trying to figure this out! :-) I have a group students and their addresses with a postal code in one set of data. I'm trying to match them to get work experience at one of our stores based on proximity of location. BUT the students addresses wont exactly...

Hi, I am trying to get a set of results which are filtered based on the selection entered. I have a spreadsheet with a list of stock items etc, and these can be duplicated because they can be in different stores. I want to be able to filter my results based on the selection of stores So in...

Hello excel experts and gurus, Its delightful to be part of such an informative forum where I learnt alot, I was a VBA newbie but thanks to this forum I got an hold on to the things in my daily work life somehow with the help of this forum and its posts. I am encountering a problem a with...

All, Could any body help me? im struggling to overcome a problem :) please see the linked spreadsheer (you don't have to activate macros, they're just used for adding new rows - hopefully ill dev this into a userform interface) We have a 'required quantity' column which is the exact amount we...

Hi Everyone, I could really use some help with my formulas- and I have searched google with no luck. So here it goes Backstory/reason- So I am currently putting together a formula driven retail scheduling report in excel for my company's 10 retail stores. These scheduling reports are broken...

Hi Excel Gurus, Once again I am very much thankful to this community due to which I learned a lot. I am stuck in the current routine although it is not giving any error and executing but its not hiding the rows as mentioned which are blank has no data. To be more precise I have selected the...

I have a dashboard that specifies this month's income from various stores and also the previous month's income, each store having its own row. I want to include a traffic light in the cell for this month that turns green if this month's income is equal to or greater than the previous months *...

Hi, I'm attempting to build a userform, but have hit a wall.. My userform currently consists of two combo boxes and a multi-select list box. All of which pull their contents from lists within the excel book. The combo boxes contain the available departments and disciplines, the ListBox has...

Hi I have a formula below that show when an item was first sent to stores. I need to filter only results that are <4 weeks on the floor. But since it's a value field I cant filter it. Can someone please help. Thanks IN STORES XXX:=CALCULATE(MAX('TRANSFERS'[FIRST SENT TO...

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

IF((or(C5="Dollar General",R5,0),(c5="Family Dollar",r5,0) or(c5="******* Barrel,r5,0)or(c5="Reserved",r5,0))) Basically have a list of stores in C. I need it to pick up the following stores and if true want it to return the amount is col R Dollar General Dollar General - SBT ******* Barrel...

Hi all, I got 1 pivot table showing Sales in the top 10 selling stores (rows) and top 10 selling products (columns) These numbers are based on 2017 numbers and i used the value filter to find make the table. I would like to compare how the same top 10 stores and products from 2017 are...

Hi everyone, I am completely new on this forum. I am thrilled to see such activity on this important subject. I work for a one of the largest FMCG companies in the world and the management has asked me to create a local report that can provide a overview of the most important products and how...