store

Hi all, question about VBA in excel here.. In essence we want to create a VBA code that automatically creates Workbooks for each type of store. As an example: We have one source workbook with the following table: <tbody> Type of store Seller Item Price A Youtube Banana 5,00 B...

HEllo Guys, I need help. I have an excel spreadsheet with three columns. Column A has store numbers, B has dates and C has dollar values as displayed below. I want to display column C values on another sheet that has Column A (store numbers) in a column and the dates in a row. I want to...

I have a very simple question regarding the SUMIFS function. I've created a spreadsheet containing all of my store purchases at a local store. Examples of categories are groceries and apparel. I want to sum up all the grocery purchases in June, July, August etc... Here is my worksheet. In...

Hello, I am trying to create an Excel workbook where users must select an original value from a drop down listing, and then fill out remaining information using additional drop down listings that are dependent upon the original drop down listing. There is one catch. The dependent drop down...

Hello, I am trying to create a shared spreadsheet where users can select an original value from a drop down listing, and then fill out remaining information using additional drop down listings that are dependent upon the original drop down listing. There is one catch. The dependent drop down...

Hello, Please could you kindly assist, I have an excel summary doc, which i am trying to prepare. The requirements are for me to provide a summary page of Raw data in a vertical way as appose to current data that is horizontally... I am trying my level best to take two variables "Store...

is there a way to make a formula to only show certain characters? I basically only want to show 0 though 9, periods, and a lowercase "x"? I need my results to look like B below: <tbody> A B 8.5 in x 11 in 8.5x11 8.5 x 11 topper 8.5x11 8.5 x 11 Store stand 8.5x11 8.5 x 11 POP 8.5x11...

I've used this site many times over the past year and have always found answers to my questions. This time, I am completely stumped so hopefully I can concisely explain what I am trying to accomplish and hope someone out there can help. I have 7 workbooks in which each workbook has over 10...

Hello, I have a table with store names in a row and store items in a column. Based on the quantity of items on hand, I am trying to see how many stores can be serviced. The meat of the table has the quantity each store needs for each item. I am trying to come up with a count-if formula that...

Full disclosure this is a cross-forum thread (excelgure.ca) since I need to find a solution quickly! https://www.excelguru.ca/forums/showthread.php?9263-Summing-area-of-data-across-multiple-tabs-with-multiple-criteria-array-and-indirect Hi Everyone, I'm spinning my wheels here between index...

Hi Everyone, Instead of using "For each Cell in Range" I was wondering if there is a way of doing "For each Range in Range" For example, in column A, I have a list of store numbers. It may appear one time, or it may appear multiples... <colgroup><col></colgroup><tbody> STORE 1358 STORE...

Hello! I currently have the following macro that highlights "offsets" in my spreadsheet. Sub Offsets() Dim Cell As Variant For Each Cell In Range("B2:B2500") Dim rng As Range Set rng = Range(Cell, Cell.Offset(1, 0)) If Application.WorksheetFunction.CountIf(Range("B2:B2500"), Cell) > 1...

Hi, I am looking for the solution on splitting the data. <tbody> Product Store 1 Store 2 Store 3 </tbody> Above are the headers in my excel. I want separate sheets for Store 1 , Store 2 and Store 3 with the common factor as product in all sheets. Please let me know how it is...

Hey Masters, Good morning! Im a newbies in VBA and want to learn more about it to speed up my work. I have this file which needs to be sorted everyday. Copy all the movements to each corresponding sites. Please see below the example. <colgroup><col><col><col span="4"><col><col...

Hello, I have set up a pivot table to summarise some report data and need to apply a 30% or 70% calculation to some of the times (format [hh]:mm:ss to create a new table of data, what would be the best way to do this? Is it possible to do it within the pivot table by referencing a matrix on...

Hi, I am trying to put a custom column by subtracting Value1 from Value2, Subtraction column is the result i got from PQ Store3 result should be -21 (null-21) & Store 5 result should be 54 (54-null). How can get the correct result Store Value1 Value2 Subtraction Store 1 1700 3544...

I am slightly familiar with the OFFSET formula. I would like to extract the data from Column B into Column F in that order, skip rows and do the same for the data for Tina Fey, etc.. Possibly one continuous formula? Is this possible? <tbody> A B C D E F 1 CLIENT INFO 2 Name Bob Ross...

Hi there, Context: - a client is getting one file per store each week with the week's order from the "most popular items". He could get 100-200 files. - each store has a code and each week the filenames change. For example on week one in June we'd have 1 master file and 100 store files named...

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

In C1 I have the beginning date of the first pay period an employee commenced work, e.g. 18/09/2015. In C2 I have the end date of that first pay period, e.g. 01/10/2015. I thought these would be useful as formula helpers. The records begin at row 6, with the date the employee began working...