lot

Hi I have a macro that I am running which takes a very long time to run - I even built a Timer function to calc and on average it takes about 8 minutes to complete!! I have tried a lot of the usual "tricks" - e.g. Calculation = Manual, SceenUpdating = False, EnableEvents = False But...

Hello, I need some help as I never had any training on excel and I'm lost! I need to retrieve airwaybills with hyperlinks. To do so I have tried a =HYPERLINK(VLOOKUP(F2,exacta!A:N,14,0)) however when I click on the link I get an error message (Cannot open the specified file). I've tried some...

Hello everyone, I have a lot going on it my workbook for work. The sheet has had a lot of modifications to it and it is now behaving slowly. It takes roughly 6 seconds to apply a filter to the worksheet when it used to take .01 seconds. If I move the worksheet into a new book the speed is right...

Hello guru's! I'm trying to get a popup window to show when a date is entered that is less than 8 months from today's date. I also need it to send out the alert when the spreadsheet is opened. Basically, Column A is the part number, Column B is the lot number and Column C is the expiration...

hey all, i have a problem and maybe someone can help me. I made a query in the power bi and I received this table: now you can see if I will go a little bit right : there's a lot of null and I don't know how to take the cells with the data (not with the null) and to put them at the end...

I have a lot of different sections that need to be conditionally formatted for instance I have a lot of different rows that need to be formatted depending on what is in row 2 However, when you go to edit in the box it looks like this...

Hi I want to move a lot of rows into columns Here is attached a small clip what I need https://www.screencast.com/t/ATXeMzkNi Can somebody help me?

Hi, I've been hours trying to find the answer for this but whatever I try wont work. I've got a large spreadsheet with lot of names on and a lot are repeated with different scores on. What I basically need is a column that averages the scores of a person. The table is massive but in a similar...

Hi, I am trying to create an inventory spreadsheet where usage removes quantities from a lot until it is completely relieved and then the next lot is subtracted from. I have completed this as below: <colgroup><col><col><col span="2"><col><col><col></colgroup><tbody> Lot Date Received Qty...

Hi friends... bothers me a lot when i open a excel book, for view and when close.... display me the window asking me if want save or not... Strange, if i dont do any change.... i am sure.. how to fix it? i want ask me if want save, only if i make changes.... thanks

Hi! Probably a very simple question but I want to create a double column chart in Excel such as this one. I have been playing around a lot but I just haven't been able to figure out how to set it up. For example, is this the right starting point? Any help would be very much appreciated...

When I select the entire sheet and double click on the columns they won't shrink to the minimum size for the data in each column? Like below. Excel 2010 <colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5""...

Hi, anyone know how to remove (or not have in the first place) the little shape that appears in the bottom right cell of a query range result? Looks like 3 building blocks making a triangle. I'm quite used to it, and use MS queries a lot, but my bosses aren't keen on the shape :( Had hoped to...

Hi all I have about 100 workbook every one hour and I want to combine all of them using ablebits data tool But it’s not free tool and I cannot buy it I searched a lot but all vba macros I found in internet doesn’t work with me So please help me to find VBA Macro to do what I want Thanks :)

Hello I want to ask some have an idea..? how can i split these numbers automatically from the picture? with a script or no other idea .. The idea is not to remove them manually one by one. The idea is not to manually pull them out one by one, that sometimes there are a lot of accounts, and I...

Hi. I want Excel to execute the following...

I require specific formula for lot wise sum of ID . The ID will re-occur but the re-occurred ID should be separately addition-ed. The ID will be nearly in 2000 number. # Do not sum all the similar Structure ID #Do not change the Structure ID <tbody> Structure ID Weight SUM A 1 A 1 3 B 2...

Hi Guy's Any idea how to I turn my data output from this.... <colgroup><col><col><col><col span="3"></colgroup><tbody> 201309 201310 201311 201312 201401 A 13000 18266 15300 7250 25050 B 0 15568.9904 15000 16900 47040 C 0 0 0 8750 126082.4 </tbody> to this very quickly please...

Found a lot of hits on Google, but they all say go to Oprions, or Ribbon etc, How can you turn them off in VBA please ?

Ive been using XLSM for ages but just found anything works the same for me in XLSB format at nearly half the filesize. Does XLSB have any cons? I've read up on it but a lot of the info is old. I read with XLSB, if file becomes corrupt its harder to fix.