order

Hello all, I have an excel file with 3 checkboxes that enable and disable conditional formatting (to find duplicates) using something like this: Sub ChkBxA() Dim rg As Range Set rg = Range("F6:H59,J6:CK47,CW6:CW1000") Dim Chk As CheckBox Set Chk =...

We have a system with an excel export, but the columns are not in the order we need, nor are they even in the same order each time we perform this export. Is it possible to redefine the columns in Excel with some VBA? I would want this done based on the contents of A1 through CY1. These...

I have two listboxes Items for Selection (this is a multi select) Items Selected When all the required items are selected the user will click a button to send them to the Items Selected Listbox. When they appear in the Selected listbox I need them to be in alphabetical order and as I am...

Hello All Having an issue with auto updating a pivot table. In my workbook I have three tab. Tab 1 - dashboard (where I want pivot tables Tab 2 - Main data Tab 3 - Consolidated Data for charting purposes Tab 2 is where I input everything. It is a grid with employee names on left and work...

Morning All, Have been trying to figure out how to do this, but failing miserably. Hoping someone can help/offer advice. Including a sample sheet to download. Completed worksheet is a selection of tickets worked by a team, a description and the customer name. On the Order Processing sheet...

Hi Expert, Im learning excel while I work on parsing large amount data. Need your help me to create a new table from old table as listed below. Your help is highly appreciated. Thank you once again in advance for your great help, Sincerely Zi <tbody> Source Table Order_Aging...

I'm working with a large table similar to the one below with thousands of Order #'s (Column A). In Column D I'm trying to identify the status of each Order # based upon the Line Description(s) in Column B associated with each unique Order #. If Column B contains "Fiber Facility - Enterprise"...

Hello, I'm trying to find out how to display only the Nth result in a query. I have a query currently that shows all Categories of question types possible, assigns a random integer and limits the results to the top 5. On my form I want to display each of those results in a separate box. The...

Hi everyone, I am a novice Excel user and I'm trying to create a dynamic sheet for my company to use. The gist is like this: I have 4 pieces of information. An event date, event name, location, and link to notes. I have these listed out in rows. What I want to do is be able to automatically...

I am a complete novice at excel, so please forgive me. I am trying to take usage data from my order catalog for two regions and combine them into one table, while keeping the usage totals in discrete columns. The items in the two catalogs are mostly the same, with a few unique items in each...

Hi All, I am trying to create a file which helps me make the most optimal filling order. It is most optimal if I minimize the switching time. When I use the solver add in to fill in the order i won't change anything. The file that i want to create is something like this table below hwere...

I have a large number of worksheets (>200) and because Excel places the sheets in order of codename and because the codenames are alphanumeric, I wind up with an order like Sheet1, Sheet100, Sheet101, etc. Is there a way re-order the sheets so they are in either the same order as the tabs or at...

Hi all, I need to change some code in my UserForm that we use toinsert orders to a WorkBook so that it incrementally updates the order number.Currently I use the code as seen below: Dim rng As Range Set rng = Cells(Rows.Count, 1).End(xlUp) rng.Offset(1) = rng + 1 ws.Cells(iRow, 2).value =...

Hello, I have 5 Fields that append to a table. All can repeat but I only want one unique record of each type. When I do the append, it just keeps adding duplicates because I can't set a primary key. Any ideas? Fields: Order Operation ID Description Complete Bear in mind...

I am trying to make an impact report that will quickly allow a customer to quickly understand the impact of set a weeks work and any delays in their schedule. What i would like to do is make a table with Column A being the project ID, Column B to BA represent a work week, and column BB be the...

I need a correct formula for calculating accruals and I hope a finance type has something ready-made as this ties me in knots. (I think everyone hates accrual accounting.) We calculate accruals in a somewhat normal accounting way. If I order a $100 widget from Zimmer, we put it on a...

Dear supporters, appreciate your support to help me i copy data from system to excel sheet (data) <colgroup><col></colgroup><tbody> A - Support A - Support A - Support B - Support B - Support B - Support B - Support B - Support B - Support C - Support C - Support C -...

Hi, I am looking for a formula of DAX to find a specific number in invoice column Eg: Invoice number always start with number 2 and it has 8 digits as shown in below table (highlighted) <tbody> <tbody> KB335/21635956/A-AMOUNT-R091018-R171018 </tbody> <tbody> 21600589/A-2 (INVOICE...

HI There, My code does NOT stop with the "On Error...." code, when i type a 'non-existant' order number. It does not take my back to "Re-try". Do i have the "On error..." code in the wrong slot within the overall code of the procedure? See below. Many thanks Private Sub...

I have this: =COUNTIF(ordertable[Column3],1B) to count all the reds in column 3 of my order table in column 1 of a table that counts the colours in the order table thus: <colgroup><col><col><col><col><col><col></colgroup><tbody> colour red green blue black etc quantity 1 0 3 1 etc...