issue

Hello, so I'm using Microsoft Excel on Office 365 and I'm using the VLOOKUP function and having some issues. Here is the current state of my formula I'm trying to troubleshoot: =VLOOKUP(C3&"*",A:B,2,FALSE) Column A is filled with identification keys composed of letters and numbers while column...

I have created an excel spreadsheet showing a list of inventory. I wanted to be able to put an X in the final column to provide an easy move to the out page. This will let me know when thing are taken out of the warehouse. I have created both worksheets. I even got the code and them up and...

Hello Wondering if an Excel expert can help. I'm wondering if this might be due to an update but i'm not entirely sure. I have a workbook at work which is used to track absence. There is a master data sheet which is refreshed with a system report every day, so on the absence sheet, all the...

My code below: Sub arrange() 'all declarations for wkshts and wbs stated at top unless stated here Dim g1 As Range Dim g2 As Range Dim g3 As Range Dim g4 As Range Dim g5 As Range Dim g6 As Range Dim g7 As Range Dim g8 As Range Dim g9 As Range Dim g10 As Range Dim g11 As Range Dim g12 As Range...

Currently I am using Microsoft Office 365 at work, version 2102 (Build 12801.21278) Steps: Execute query> copy results and paste into new workbook>Insert Pivot table on all data>add columns and rows When using a Pivot table in 365, if I attempt to double click a cell to show the records behind...

Hi there! Just wondering if someone can point me in the right direction for this, as it's been racking my brain trying to figure this out. Basically, I'm retrieving data from another table using the formula =VLOOKUP([@[Entry Number]], 'sheet3'!$B$2:$M$191,2,FALSE), which is fine working well...

Hi All, My team use a shared, macro-enabled (.xlsm) workbook, with roughly 25 users in it at the same time, 24 hours a day. Over a few days, the shared user list gets full up, sometimes people's entries appear in there 4 or 5 times each. This causes the workbook to get bogged down which...

Hi, I have a button inside Excel workbook which exports certain pages to PDF with one click on a button. The Excel version I am using is Professional Pro Plus 2019 and my customers version is the same build, but an Office 365 version. If I hit the button in my version it works, but if my...

Hi, I don't know if anyone can help, I am not that experienced when it comes to VBA, I have found the following code online & modified it slightly to fit my needs. I am trying to copy a module called PrintQTYPAGESASCELL() If I am honest, I don't understand what each line is doing, I think I am...

Hi, I'm having a performance issue while running the following formula: "=Calculate(sum(lines[CB unit]),Filter(Lines,Lines[Index]<=earlier(Lines[index]))" I'm only iterating over 150K rows, but the calculation times out and never seems to finish. It works fine with 2K rows, but really starts...

=IF(C7="Rosemont University",E7*$P$28,IF(C7="Clayborn University",E7*$P$28,IF(C7="Branch College",E7*$P$28,IF(C7="Eastern Wisconsin University",E7*$P$28)))) My issue is that I can seem to remove False from my cells. Any help is appreciated

Hi Guys, I have an issue with a formula. I need an if between dates with in the middle August. Example: 12/06/2019 12/10/2019 If in the range there is august do something, otherwise something else. I have no idea how to write it. Thank you guys, Have a nice weekend.

Hello All, Working on a weird issue here. Look on the interwebs and found nothing for my specific issue. The DateValue syntax doesn't seem to work in the event the data string makes no sense. So here is how some of the dates come in; <tbody> Date as it comes in Converted to General...

i want a macro that loops from column K in sheet I'll call "ABC" and checks the values against a data range called "filter" (which is in another sheet called "filter criteria") if it finds a row in column K that's also found in the data range "filter" (eg the number 005), then it'll zero out...

Hello, I have 2 problems that I am trying to solved. I did my best to search forums but I just cannot seem to find answers (Probably I am not able to interpret the issue properly, been learning excel for more than a month now) 1. trying to use...

Hi mrexcel forum, Could you please suggest a formula to help me with this issue? Issue A: I will like to extract out the numbers immediately before and after the dot. This is the volume information. Issue B: I will like to extract the 3 characters immediately after the Volume information...

Hi I just wanted to know why excel is not consistent here. I wrote the code below. When I call Data() excel will remove () and keep Date only; However when I used Time(), excel will keep the () It is not big issue but curious why there is not consistency here. Sub mytest2() MsgBox Date...

Hi, I'm using Excel 2016 64bit on Win10. I have a 195Mb workbook, 7 sheets. Set to manual recalc and the book calcs in 2-3 seconds which is fine. My issue is that enter entering a value in one of the 50 or so input cells (all on sheet1), excel is typically unresponsive for up to 20 seconds...

I'm experiencing an issue where the manual check of formatting for a particular cell does not match what the Range.DisplayFormat.NumberFormat returns (I've tried .NumberFormatLocal also). It appears it is replacing parenthesis characters () with a hyphen -. What I'm trying to do: A client has...

Hey all new here. I am having an issue changing code to place textbox value to current active sheet rather than a specific sheet. I am working my way through to create an active form to generate data based on scanning an item into a single textbox. TextBox1.Font.Size = 28...