shop

Hi, I'm using index match reference, but I have to change every formula one by one, is there a faster way? https://ibb.co/X2pcKzP See the photo attached, I have to change the formula in G56 from '[7 July Shop Yields.xlsx]1.7' to '[7 July Shop Yields.xlsx]2.7'! manually but whereby F56 already...

Hi all. I have a user form with two buttons for a selection by the user. It is either the one or the other. You can not select both. If you select Mobile then the word "Mobile" is to be in cell M1. If you select In Shop then the text "In Shop" is to appear in cell M1. If no button is selected...

hello, i have an issue with some of my colleagues when typing for example shop names, not all of them write it the same way so i need a way to look for the written name in the excel report and look it up from the correct table. Example: Wrong Spelling/Name <tbody> Carrfour Maadi Correct...

A program I use outputs data in a non-pivot friendly format. It has already grouped the data with different levels. I am trying to convert this data into data that is pivot table friendly. I currently have data like this where Location is always filled out and will have at least one (but...

Hi all I've been trying to come up with a solution for a little while but am just not seeing what I need to do to get there... I was hoping someone on these excellent forums may be able to assist? Background: I have 5 tables with 12 columns each (i.e. months) in my back pages. The 5 tables...

Hi, please help I’m stuck. I have been trying to write this with no success. I have two worksheets that I’m working from; Sheet1 will have a shop order reference number in cell C4. I would like to search Sheet2 Column C for the corresponding Shop order then proceed to copy the shop order and all...

HI I'm using excel 2016 the following macro deletes all the rows of data when the word "SHOP" is found in column c the issue I have is if the word "SHOP" is not found than all the data is removed except just one row how can I change this Sub Macro2() Application.ScreenUpdating = False...

Hi folks, I am wondering is there a way to summarise the table below so that it lets me know if an event had only newcomers, only returns, or returns and newcomers. For instance, I am trying to distill this table down to: On 11/11/19, the "Shop" had "New and Return" customers while the "Show"...

I hope this will not be too difficult to explain but this is a tough one. I have 3 columns, A, B & C and each column has about 10 rows. Each cell is formatted to be a date. So for example, the rows are broken down into weeks, so the first 10 rows will be week 1, the next rows will be week 2...

Hello, There is a warehouse with products. Every product consists of boxes with different weight. Every time a box from a warehouse goes to the shop it should be highlighted. So if the same weight from the warehouse is entered in the shop area, they both should be highlighted. But sometimes...

Hi friends, I have a Sales Incentive Program that payouts to staff based on their designation and % achieved. Below is the criteria table. <tbody> Designation Pay-1 90% Pay-2 100% Pay-3 110% Pay-4 120% Sales Associate 60 100 150 300 Watches Technician 60 100 150 300 Senior Sales...

Greetings! So I am currently working on a project at my job. It is something that I can do by hand, but requires a tedious amount of time. I'll try to explain briefly and then I need help figuring out how to use formulas to make this easier. We create hot rods from the ground up. We have...

Hi All, I need some help with constructing a formula. Basically I have a three column table, one column is transfer document, one is shop and one is goods code in the shop. What I'd like to see is what is the goods code of the same goods in the different shops. The only connection between the...

Hi all, I'm trying to find a formula that will allow me to search multiple tables with multiple criteria e.g: I have a main sheet with multiple criteria: shop name, engine type, type of service. I then need to use these criteria to search within a number of different tables set out like...

Hi, i'm trying to build load plan in which i require multipul shop cage counts to add up and then see where they fit on to a wagon. i have got that part done but im wondering if it is possible to fill in, as many boxes with a shop name as there are in the sum? wagon would be 3 boxes wide ,by...

Can anybody share Excel Work Sheet for Grocery Shop Complete Inventory Control

Can anybody share me a Excel Work Sheet for Grocery Shop Complete Inventory Control

Dear Mr. Excel Can you please help me to prepare the data on excel sheet as per attachment. Regards <colgroup><col span="4"><col><col span="2"><col><col><col span="5"><col><col><col><col><col><col span="2"><col><col><col><col><col span="2"><col><col><col><col><col><col...

Hello all, I am struggling to find a solution to my problem which is as below: I have a excel workbook with name - sales.xlsx which has 3 worksheets - online, shop and master. Currently we enter the data manually to worksheets online and shop. We want a macro which can automatically copy over...

Hi, My table is as follows: <tbody> Shop Fruit A Apple A Apple A Pear B Strawberry B Banana B Orange B Banana </tbody> And I need a DAX formula to create the following table: <tbody> Shop Fruit A Apple A Pear B Strawberry B Banana B Orange </tbody> Which...