store

I have a spreadsheet for each of the 3 small stores I own. One part of each simply calculates the frequency with which each item in store sells. I want to compare these sales indices so have a consolidated spreadsheet in to which I = the calculated indices. Trouble is each time I sort the the...

How can I change name of cells if 1 cell changes name. If A1 has the name "Store Rack 1" then Cells display names Pens, platic Bags, Paper in cells D5, F5, H5 If A1 has the name "Store Rack 2" then Cells display names eraser, Box, Pencil in cells D5, F5, H5 Example:1 If Cell A1 = Store Rack...

Win 7, Access 2007 I am trying to import a word document and store the document as a memo field. Then print the word document. Do not have a clue as how to do this.Suggestions welcome. tia Jack

Hello! I'm hoping for help on a formula. Here is my source data: <tbody> A B C D E F G H I J K L M N O 1 Employee ID Name JobCode Jobtitle Store Number Secondary Store Hire Dt Rehire Dt Termination Disciplinary Start Date End Date Days LOA Annual Rate 2 1234 EEA 01574 OTSA 1021...

Hi all, im new to macros and was hoping someone can helpme. I need the macro to archive a sheet and store it in my H drive, can anyone help me?

Surely this has been asked, but I couldn't find the exact issue searching: I've got a bunch of dynamic, personalized spreadsheets I'm trying to get some templated data out of. To do that, I need to search Column A for a string, then move over a column, down a few rows and add a vertical range...

I’ve been stuck on this problem for a while now. I have a large spreadsheet that I am trying to find when and where the 5th occurrence happens. I would like to use a helper column to display the values if not a list of the location and time would work. Below is an example. <tbody>...

I am working in a indutstry as store keeper. i want to manage store inventory but can't find a proper way to do this. could you help me how to manage this.

I am working in a indutstry as store keeper. i want to manage store inventory but can't find a proper way to do this. could you help me how to manage this.

Hi all, hope someone can help here. I supply a retail chain with stock and receive data from a sales cube. I want to look at sales for the past 4 weeks and if they are in decline or don't meet a target I would like excel to trigger a 'Visit' so I can go to/contact the store to see whats up. Is...

I have 3 sheets that I am using Vlookup formula to pull data from based on a condition in a cell; A2 on Sheet4. And the conditions are A, B, C. If A, then I am looking up the value in B2 on Sheet4 from sheet1 range A2:D30 . If B then same value in B2 Sheet4 but now on sheet2 in that order...

I have a sheet of sales with 7 blocks of daily data, Sunday to Sat. one block for each day. They are by store, down, and dept, across. I have another spreadsheet report with 34 taps, one for each store. Each with one block for each day of the week. I need to look up values from the sheet of...

Hi guys, I have to following problem: in a workbook with many sheets I have to update several worksheets (Store A,B,C,D,E,F,G,H, etc). But I would like to have a overview sheet (Info) where all worksheets are named with a time stamp when the sheet was updated Overview sheet is called Info...

Hi all, I have what i thought was a simple task, but cannot resolve. Simply put analysis server has millions of rows of data, i would like to be able to do download 1 day or one store only, like when using sql query and cell value. Set date or store and refresh. Not sure how to do this, please...

Hi all, I have data on 3 different tabs. 1 for stock on hand, 1 for sales, and i need to convert them to the the way i have it on the "Data for Pivot" tab. The data i have cannot be changed as this is the format i get it in. I basically want to combine SOH and sales by store, but then be able...

I use vLOOKUP a lot, but haven't gotten into Index Match much. What I'm looking to do is get the column AR in the Sheet "Order Detail" to return the Name of an employee from "EMP List" by cross referencing the Store and Team Member ID. I can't use vLOOKUP because some employees have the Same...

Hi all I have a loop amongst other things evaluates the following formula: prodcount = WorksheetFunction.CountIf(Range("CATGRPS"), Range("Cat_List_Unique").Cells(i + 1, 1)) Obviously when it loops back onto the next "i" then prodcount resets, How can i adapt it so where "i" is 1 i would...

Hi all, hope you can help please!! I have a s/sheet with many columns of categories (types of items sold) that have our stores (listed as store numbers) listed from high to low in each column. I want to create a summary tab for each store, listing their rank in each category. Top is what I...

Hi all, I get it that SUMIF(S) doesn't work with closed workbooks. Normally, SUMPRODUCT works fine in such scenarios. Except, if I have many lookup values. I can't figure out an easy way to resolve other than a very long/ugly SUMPRODUCT. E.g. <tbody> Stores to sum sales Location of sales...

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