variable data

Apologies for the convoluted title but I couldn't think of a simpler way to put it without losing some fo the problem. Background: I have a sheet that populates two tables by running queries on an SQL database we operate from. It contains information relating to moving goods around a warehouse...

I have a column that includes two letters, EZ, then the date, followed by rack number, for labels. These decrement down the column as such: EZ12151736, EZ12151735, EZ12151734.... When the last two numbers reach 01, it starts over with the previous day: EZ12141736, EZ12141735.... I have this done...

This is my first time posting here. I searched for posts that were similar to mine, but may not have navigated the forums as well as I should have. The assistance I require is this: I created a spreadsheet that allows the user to paste in data from five other reports and then it uses array...

Hi, I have put together a table with roof pitch (0.5-30 deg) along the top and roof area (5-800m2) down the side, these are my two variables that I would like to select in two separate drop down menus. Based on the selection of roof pitch and roof area selected in these two drop down menus, I...

Hello, I have a spreadsheet with multiple variable tables. I would like to get a count of rows for each table. The tables are separated by a blank row. Is there a way I can do this using VBA? The pattern could look something like this. 4 rows of data blank row 3 rows of data blank row 7 rows...

I have a spreadsheet with approximately 20 different tabs, each having a separate budget that is split into 3 sections. I've also got a master tab that I'm looking log all transactions/invoices related to any or all of the budgets on all the tabs. I would like to create a formula that...

So, here's my dilemma: I do Loss Prevention work, and I'm trying to pull information from a worksheet into a simplified table for a region of about 150 stores, which would be 150 different excel spreadsheets. The problem is that the information varies from each store... Example: Store 1234...

I have a workbook where I perform an advanced filter and from there create a dropdown list. Now I need to have the user select an item from the dropdown list. This selection then needs to be "read" and use this selection to copy the specific items to another workbook. Right now, the only...

Apologies for the vague title but I'm not sure how best to describe this challenge. I have a log from our GPS tracking system for all of our company trailers. I am trying to work out how long each trailer stayed on site at a particular destination for. The first complication is that for each...

a few times a year I have to make some special signage up from three columns A1: Item B1: Number of Tickets to get Item C1: How many signs are needed so for example A1: Gadget B1: 100 Tickets C1: 3 Which I have to convert into A1: Gadget B1: 100 Tickets C1: Gadget D1: 100 Tickets E1: Gadget...

Hi, I have been tinkering with a spread sheet in order to make it easier to navigate. The data is exported straight from our system and then dumped in (A1) the workbook. The data layout is the same each month regarding the columns but the number of Rows differs each month. The reason this is...

Hi, I wanted to ask if there is a way to use a SUMIFS with a criteria set that can “vary”??? Need to “SUMIFS” with multiple factors (DATE, ROOM NUMBER, ROOM USED FOR, etc) such that the ROOM IS USED for either ALL TYPES OF PROCEDURES(ELECTIVE, URGENT, EMERGENT, Add-On), ELECTIVE ONLY or...

I have a macro that compares two sheets (in a workbook that might contain 10 sheets). Currently, the user enters the names of the two sheets in two input boxes. Is there a way that the user need only to click on a sheet tab and the sheet names are used in the macro? (this would eliminate any...

Hi everyone, A bit of a challenge with this one... The last couple of hours searching have not resulted in a working solution:confused:, so I turn to you. I have 253 cells in column AO that contain text, containing 1 to 6 chunks of text within "double quotes". Here is an example. This is...

Hello Everyone, I need some help regarding filtering in excel, and would greatly appreciate any assistance. I would like to be able to filter by variable criteria, and possibly by multiple variable criteria. Allow me to explain this as simple as I possibly can :stickouttounge: I have a...

Hello everybody, Here is my original code, which goes down column F, from F4 on-wards. It averages 5 cells at a time, the result of which it places in column G, from G4 on-wards. It uses relative values, so cell G14 will have the value of F14:18/5 and so on. Range("g4", "g250").Formula =...