Pinned Posts
Forum Widgets
Latest Discussions
Excel Code trying to copy cell data from one sheet to another based on 2 criteria
Sheet "My Plan" Sheet "Tracker" I have several plans in external files that I have code for to select and import 1 to sheet "My Plan". I am using cell E6 as a named cell called PlanName and I select the name of the plan from a dropdown. Column D which is "Unique ID" Column I which is "Baseline Date" Column L which is "% Complete" Sheet "Tracker" is a Table called "Table1" I am looking for code (which I will activate by a button) which will look on sheet "Tracker" column Name "Workstream / Project" and if it doesn't match "PlanName" then go to the next row. If it matches then it needs to compare from sheet "My Plan" column D with sheet "Tracker" field "Plan Unique ID". If they are the same it needs to copy sheet "My Plan" column I and L to sheet "Tracker" fields "Baseline Due Date" and "Percentage Complete %". Great if you can help
Data validation based on value in a cell
Good afternoon, If anyone could help, this would be great. I'm trying to build an Excel in which I can pick a brand in a cell based on data validation, than in another cell I would like to pick a series based on a reduced data validation. And so on with Typenummers. So ideally, I would like to pick a Merk (for this example Lekker), then pick a Serie from a drop down that only shows XL and S (for this example S), and that select a Typenummers from a drop down that only shows 753 and 159. Any advice is welcome, thanks! Reinier - The Netherlands
Excel - Matching outgoing to incoming inventory based a specific conditions
Hello, I wonder if anyone here can help me. I have created an inventory tracking file in excel but I have encountered a difficulty that I cannot seem to find an answer for. I have sequenced each incoming shipment but I am unable to sequence or match or track outgoing shipments automatically based on specific conditions: I need to assign #1 to outgoing shipments until outgoing piece count of 25 is reached, then #2 until 20 is reached and so on When incoming and outgoing piece count net out to 0, I need the status to be "Closed", when we've started pulling from but not emptied out yet, "In progress", and when untouched "Open" I would like outgoing to be link to earliest, not closed, incoming shipment. Of concern: "Out" and "Status" columns Can anyone help with this? Thank you! Christine
Maximum number of arrays to use with SUMIFS
Hi, I have a situation where I need to sum a column where it would be ideal if SUMIFS could use three (or more) arrays in M365. The following sample SUMIFS nested in a sum statement works fine, but I'd like to add a third column/array after {"D";"E"}. Can anyone tell me if this can be done or should I just use multiple SUMIFS formulas without arrays. I've tried researching this and the closest answer is to use the semi-colon in the second array. However, I'm unable to find information about adding a third array. =SUM(SUMIFS(DATA[Eligibility], DATA[Location], {"A","B"}, DATA[SchoolType], {"D";"E"})) Appreciate your thoughts and suggestions.
How do I unlock an unopened Excel document?
My problem: I attempt to open a document, it hangs during the load at the "Accessing Printer" of the loading prompt. The result is a lock on an unopened document that cannot be closed at the Task Manager but not seen by Taskkill at the command prompt. The Scenario: In the image (scenario) below, PID 114776 hung when the "accessing printer" message appeared on the Excel loading prompt. When I close the prompt, the Excel task (14776) remains but cannot be ended in the Task Manager (i.e., selecting End Task), nor can it be ended via the command line because the Taskkill cannot see the process. The Result: If I attempt to open the document, then logically a separate task process opens, but the locking message appears because the unopened document is locked for editing and there is no way to kill that process that I know of - other than going through an entire computer reboot. I'm using Office - Excel 2019.
