store

Hey guys, I'm writing a code to count and store values to reference how often something is referenced in a class. I'm trying to write a code that counts with one button (this is complete) and stores historical values in another column. This is where I'm having issues. My counter is set in B2...

Hi everyone, I'm new to this forum but have spent a lot of time reading through other's posts, which are often very helpful. I haven't found a definitive answer to the following question and hoping you all might be able to provide some guidance. I am pretty new to Power Pivot - thank you in...

Hi - I have a column with stock numbers (1 or 2 letters with 5 digits following). I need to them to match with the correct store in another column - The store is determined by the first 1 or 2 letters (ex - KU12345 would match Jones Kia and B67890 would match Bloom Chevrolet . Also, some of...

I rarely post questions on here as I've so often been able to find posts on how to solve my problem. In this case, I'm struggling. I want to chart data based on the selection of a Store. How do I do this? <colgroup><col><col><col><col><col></colgroup><tbody> Gross Sales Oct-18 Nov-18...

Hi guys! long time no post! I was asked to do something at work that I havn't done in a while, but luckily I saved the VBA script, its a script that matched different workbook sheet store numbers and exports them to their corresponding network folders, luckily most of the script still works...

I am fairly new to vba and thought I could take on a small userform. Joke is on me, a simple vlookup is kicking my butt. I have a userform that I simply want to use to lookup data from my spreadsheet. I don't need to edit anything, just display data in textboxes. Static named range is - master...

i have the following code in a vba macro which works just find if I always insert the two cell numbers before executing the macro. (where the values are) N25 and M21 My intent is to build a dynamic string and store it in Column A:Lastrow+10 Can I somehow make them dynamic and use the last...

Hi Hope you are doing well!! I need to create an excel sheet for store support. Application details: I have a material which has a QR code and some Location racks with QR Code. Whenever i get the material to my store i will scan QR code in material and rack.this two data should be recorded in...

Hi I need some help setting up a pivot table. I need to compare sales figures from 2 seperate years for example sales figures from week 1 2016 against sales figures for week 1 2017 for each store. I then need to be able to show the monetary difference between each year and the % difference...

hi all, Just a question of possibility first of all. I have a .txt file that contains two sets of data. The sets always start with DXS and end with DXE. First of all, I would like excel to read the .txt and take only the data between DXS and DXE and dump them side by side 1 line per row in...

Dear All, I'm having a very hard time trying sort data in Column C from largest to smallest and also maintaining the row grouping. Can someone please help me by creating VBA code which can handle this task? Screenshot below without row grouping Sheet1 <colgroup><col style="width: 30px;"><col...

Hi I have always used Vlookup but now I need a little bit more. I have a spreadsheet where 90% of the data and columns will remain the same but the on hand qty will always change. I created a small sample sheet where I have column A two different stores that care the same product number and on...

I want to scramble a given string then store the various combinations to a variable or an array based on what you think is cool for my demand. I came across this pieces but they are not exactly what I wanted. Now this is what I wanna achieve; my code will take a string in the form “AABB” eg...

Hello, My apologies if this has been asked before. I read through several threads and can't seem to find exactly what I need. Basically, in column A, there is a list of locations in groups of two that the names in column B are assigned to in pairs. The list in column B is larger than the...

Hi All I have the following code that searches a network folder for a PDF doc based on the number in a cell and opens it if one exists: Sub OpenPDF_3() Dim strPath As String Dim strFileName As String strPath = "\\172.27.154.13\D$\Excel Dashboard\Inventory" If Right(strPath...

Hi there, I know this is a pretty easy one, but can't get this to work. I have a bunch of data rows and if all the cells are not Bold in a row, then delete the row (just delete within data range, not entire row). Otherwise, if there is a cell in the row that is Bold, then leave row as is...

Hello This is my first real dab into PowerPivot, PowerQuery and data moddeling so go easy on me:) So this is the setting, I need to combine staff data into one big pivot table that can be easily worked with. I have an employee workbook template that will be copied and used for everyone and in...

Let's say I have the store column below. I'm trying to make a formula that will scrub the column and return an output with just the type of store as shown in the "Desired Output" column. Because the amount of words before/after the type varies, I couldn't use the mid function to look for a set...

Hi all, I have a data in Table 1 looking like below and I've been trying to get the sum of all May YTD and May YTG amounts (to put in Table 2) for each store by using SUMPRODUCT but i keep getting #N/As. The formula I came up with is (for example, i want to get the figure for Store A)...

Dear All, I need help for building a Macro for my store balance for all products. My original excel file is here: https://drive.google.com/file/d/1dpASKSVYVb2BUu7HqSryIEsv-Yc31pSf/view?usp=sharing There are some sheets in the workbook. In the sheet named "Previous Database", I have arranged...