load

Hello all you MrExcel experts I have a sheet with 26 columns and approximately 250,000 rows of data. The number of columns will stay the same, however, the number of rows will increase. I will be comparing data in columns 'B, D, N, Q', and depending of the results of that comparison, some...

Hi, This code is giving me a headache and I need someone fix it for me. Currently both controls are loading the image from same folder "Picture1". I want the second control to load from "picture2". I have tried some stuffs but the script keeps laughing at me:laugh: . Private Sub...

Hi, I am trying to calculate the optimal way to load containers. I have the current amount of fuel in each container and I have the amount of fuel I know will burn in aggregate prior to reaching my terminus where I will refuel the containers. I can choose which container I burn fuel from. I...

Private Sub lstView_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Dim n As Integer, ac As Integer, i As Integer i = Me.lstView.ListIndex With lstView For ac = 1 To .ColumnCount .TextColumn = ac Me.Controls("Rw" & ac).Value = .Text Next ac...

Hello, I want to find out if this code below here can be made to load the data into a listbox instead of pasting it to the sheet. My knowledge is limited with the how. Thanks in advance. Sub FilterDates() Dim rCrit As Range Sheets("HOME").UsedRange.ClearContents With...

Hello, I have struck out all day trying to find an answer to my problem. I would really appreciate any assistance that you can offer. I have a UserForm with an InkPicture that I am using for approval signatures. Long story short, I have been able to save the ink strokes to the active Excel...

So has there been a recent Excel update that would cause the vba code saying "Load frmFormName" to now cause this error: "Run-time error '380': Could not set the List property. Invalid property value." Using this same command worked for 2 years, and now all of the sudden it fails... any help...

Hi guys I need to load an Excel file with a button, then process and modify it and change it to txt or pdf after the changes. Can I do this with VBA?any body can help me plz? :)

Hi, I've tried searching for this online and can't find exactly what I need. What code can I use to have my comment and image load from column H on the second sheet into the first sheet when typing in the corresponding lookup value. https://imgur.com/a/bIdWfai

I have the following queries set up: 1) FY131415 (357,000 rows) 2) FY151617 (6,146,235 rows) 3) AllFY (6,503,415 rows) This is just a combination of query 1 and 2 It takes a total of about 25 minutes to load this power query workbook and the data is updated daily so I need to update...

Hi, I have SQL connection that load data into Excel Table. I have set sorting criteria in that table (Excel Table, not SQL query) so my question is: Will this sorting still be valid after data load refreshing??

Hello! I have 2 reports that are on separate sheets, 1 & 2. Both contain a load id # and I would like to enter a formula on Sheet 1 that tells me whether or not that load id # is on sheet 2, returning either a yes or no value. To achieve this, I have the following formula...

I am trying to load access data into excel but I am getting an error message that says: The requested operation cannot be performed on a file with a user-mapped section open... Does anyone know what I need to do in order to be able to load the data to the data model. Here is the message: The...

I have very basic user Excel knowledge. I have a spreadsheet where I keep track of reloading data. Each load I enter gets a unique load number that is calculated automatically with a formula, based on the caliber name and a incrementally increasing number. As of now, every load I enter gets a...

I have basic Excel knowledge and very little VBA. I have a spreadsheet where I keep all my reloading data. I keep all this data in a master sheet and add new loads to this sheet as needed. I reload multiple calibers and would like to sort each caliber to its own specific sheet with a macro...

Hello... I'm using Excel 2010 and I have an issue with some pictures. I load some pictures with the below code and I want to remove a specific one or bring in front the other one. The problem is that any time I load a picture the excel name is different and I dont know a way to find that name to...

Hi Where can I find excel files which has raw data need to be cleaned/formatted etc, remove duplicate, blank cells etc. I want to practice that on real life files. Is there any website I can down load these files from? Thank you very much.

I'm writing a macro with a date picker but it won't load on the machine that I'm testing it on. I'm using 2007 on both machines. On the test machine, I noticed there is only the Office12 folder in the installation folder. On the machine I'm working on, there are several folders. I downloaded the...

I am making a model of Electric vehicle load on electric grid. I was using formulas to calculates things but now what i need to do will not be possible with formulas. I have not worked with VBA before so have no idea how to do it. if someone can help, it will be great. I have attached a part of...

hi all. my question is: How To load a Excel File (a Macro) when Excel is Opened? i want load a custom Ribbon, always and i think is the uniqe way... i am reading: http://www.rondebruin.nl/win/s2/win001.htm Any ideas? thanks