lot

Hi All, I received a really good response from here before and I am hoping someone can help me again. I browsed for an answer but it does not exist so far. I'll explain what I am trying to do and also what I have so far. I have a large table with a lot of data. I have some dropdowns in B2:B9...

Hi All, I received a really good response from here before and I am hoping someone can help me again. I browsed for an answer but it does not exist so far. I'll explain what I am trying to do and also what I have so far. I have a large table with a lot of data. I have some dropdowns in B2:B9...

Glad I have learned a lot here and have been able to help others.

I have a workbook with a lot of data. The data is in about 100 different, 1 collumn tables with unique names. Then i have different userforms with comboboxes in it. I want to populate the comboboxes with the data from the different tables, but without referring to sheetnames. In this way I...

Hi, The VBA line below does Filter / Number Filters / Custom Filter / Begins with 1 ActiveSheet.Range(Selection, Selection.End(xlUp)).AutoFilter Field:=1, Criteria1:="1*" and the result is nul, which is incorrect, because I was expecting to see a lot of lines that met this criteria. However...

Hello, I have two separate files. In one I have many sheets (one for each production lot) in which weekly evaluations are registered (I grade them from 1-5), for example: File: Weekly Evaluations Sheet: Lot 1 (Column A).................(Column B)........................(Column C)...

I want my formula in cell V5 to process only if there is an an "X" in cell B5..,I have a lot going on and I can't get the function to take...any help? =IF(T5="","",IF(U5="","",CEILING((T5*U5/60),0.5))) Here is a link to my dropbox with a snapshot...

I have a problem. I was lookin every where but im to dumb i assume hope someone here will help with macro :) In first worksheet i have kind of comparission database A:J titles on first Line of course In second i have to fill up form from A to F Just write down any numbers How to find...

I am working on a project that has to handle large volumes of data. I can find a lot of information about how to declare and size a dynamic array in VBA but not a lot about how VBA allocates memory under the covers when you make those calls. Can anyone point me towards information in this regard?

Hi everyone, im unable to open my workbook due to the code below Private Sub Workbook_Open() Dim user as string User = Inputbox ("Please type your password") If typename(user)="albert" Msgbox "thank you" Else activeworkbook.Close End sub I tried a lot typing albert in the inputbox but still...

I have a userform and a combox in the userform. the combox ragne is autofilled from sheet 1 range c3 till the last record. I am not sure, If the user selects any record from me.combox then the code should do autofilter from c3:aa500, (c3 to aa3 are header) and then should stop at the visible...

Hi there, I'm super glad to have found you all! I am looking for a query much like this one - Date()-Weekday(Date(),2)-56 I don't want it to be all the dates inside the 56. I just need the query to pull the Sunday from 13 weeks ago date data. Can that happen? I have a lot of different queries...

I have a worksheet with many tables in it. In that sheet there is a table "EBank2". I need to add multiple rows in this table based on the value in an input box. Further, If it may help me add rows below a specific active cell, would be great. I have tried many codes but nothing has worked...

Hello, I have a below table: <tbody> Month x MONTH x+1 Volume month x Volume month x+1 PRODUCT 1 7 8 100 50 </tbody> I would like to convert it to the following: <tbody> Month Volume PRODUCT 1 7 100 PRODUCT 1 8 50 </tbody> Is there any easy way to do this? Thanks a lot

I have a table with several broad headings at the top. Each of those headings have 3 sub headings. Is there a formula to access each column as all I can think of are a few if statements? (I don't know a lot about excel)

Hi to all, hope you are well I have just entered the VBA world, and I would like your support regarding the below code in which VBA is not accepting it range("A3", range("A1").End(xlDown)).Select please note that I'm using excel 2016 thanks a lot in advance

Range("a2:a1000").Select For Each r In Selection If r.Value >0 Then r.Offset(0, 3) = Now() End If Next r I know theres probably a way without selecting, these sometimes run slow when making changes to a lot of cells

Hi! I have read a lot about this topic, but unfortunately there are no codes which work with excel 2016 too. I need a macro, which exports for example the range of A1-E10 to the desktop as a jpg file. Do you know a solution maybe? Thank you for your help, it means a lot me! Have a very...

Hi! I'm new to VBA, and I've had a lot of help reading this forum and the extreme knowledge within, thank you all for that. Now a question that I haven't found the answer to: I have a column each for id, name, mother and father. I need a new column with an unique id that connects the...

Hey, everyone, I just joined a company a couple of weeks ago and I realized that the department I'm working on has a lot of room for improvement. I don't want to get into details, but we deal with risk management. As we can imagine, we have excel files with hundreds of risks and KRIs that were...