lot

Newbie here so please be kind. lol So what I have; a lot number(1234) entered into H1, a station ID#(A,B,C or D) in H2 and the current date and time in H3. What I am trying to do is reference the lot number and station ID# then enter the current date into that intersected cell. <tbody>...

Hi Mr Excel, Good afternoon! First of all i would like to thank you for your uploaded video on you tube.i have learnt a lot having watched them. i was know nothing about excel,but your videos lot helped me to understand excel from basic to advance level. i was normal labor in company of...

Sub splitLot()<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;"> i = 0 ansSplit = 0 ans = MsgBox("Is this a split Lot?", vbQuestion + vbYesNo, "Split Lot") If ans = vbNo Then frmPackageYield.Show...

Hi, guys, I have a lot excel files (Client offers) that have the same identical format and products(The products are in same column, but not in sequence). They all have different prices.What I am trying to do is write a macro that goes into each file, looking for exact product price and copy...

I have data in the below format: <colgroup><col span="2"><col><col span="5"></colgroup><tbody> BOAT NO LOT NO D1 D2 D3 D4 D5 STATUS F4/337 5973 10.6 10.59 10.59 10.59 10.59 ACC F4/338 5973 10.6 10.58 10.59 10.6 10.6 ACC F4/339 5915 10.61 10.62 10.61 10.61 10.62 ACC F4/340 5986 10.59...

I have a large no. of entries in excel like below: <colgroup><col span="2"><col><col span="5"></colgroup><tbody> <colgroup><col span="2"><col><col span="5"></colgroup><tbody> BOAT NO LOT NO Density STATUS F2/146 5820 10.48 10.49 10.48 10.5 10.49 ACC 10.49 10.49 10.49...

hi guys having problem i trying create a code so depend on what day it is the code change prefix is L and the next two number is YY year and the 3 last numbers is DDD (001 - 366) but in number format not words like Sun or Mon so in the case than 366 would be Feb 29 or 206 would be...

I am not sure why this code does not worked because I used a similar variation in another project and it worked. I checked the file location of the file and path needing to be opened and its correct. Not sure why its not finding the workbook. The error occurs on the Set wb =...

Hi! Can you help me to avoid duplicated records on importation from excel to acces? Need to add a VBA code line in order to do so.. Thanks a lot for you invaluable help.! Regards

hello All . i have a question i have a table with name po and qty and lot i need result lot how like i post image in image i give fist lot until his lot vale equal or grater then his total then pick next lot until his balance equal and grater then to qty ...

Hi all. Could anyone please help with a division query. The Lots have been split into separate lines from the codes in Column C. The total cost of the Lots combined are in Column E Is there a way to divide the total cost by the number of items in the Lot As there are 7 items within Lot 668...

I'm looking for a formula that lets me input a value, and the output would be a list of whatever sheets in the workbook that value appears on. I don't have the slightest idea in this case, or know if it's even possible. It can't be VBA because our work computers can't all handle it. Longer...

I have been using Excel since it came out. Never really had this issue come up. On large files with a lot of calculations, I keep the Calc off which allows me to insert rows, columns, cut and paste without delay. Files over 100 MB, multiple pages - not a problem. But now I have a spreadsheet...

I have a lot of rows with cognitive data, range 20-80 (standardized T-scores) in column B that I want to represent visually in column C with a symbol (square or small circle) that correspont to the T-score scale in the first row (20-80). In addition, I need vertical lines that represent the...

How can I accomplish closing an Excel workbook and it's except window completely. But I don't want it to close the entire application unless it is the only one left open! So in a lot of cases, I have a lot of Excel books open. So using the application (.) Quit command cannot be used because it...

Hi clever folks, Just a very quick query, is it possible to click a cell rather than typing in the cell ref? Rather than typing in: Range ("A1") I would like to type Range(" and then click the cell in excel to fill in the range details. I know this is lazy but I have a lot of very small...

Hello everyone,This is probably quite a simple request however I am having a lot of trouble with it.I would like to write to a cell the previous cells time value + 10 seconds. I have tried several approaches after a lot of googling, however below is what I started with and what I would like to...

need to create a searchable database for website which has lot of photos please help me ASAP thanks

HI everyone, this is my formula which is pretty basic as i am not a super user of excel!! I have this copied down a column so it looks at the next row each time and returns if there is a match - however, i now have a column that has a lot of blank cells where this is no match - is there a way...

Hello all, Merry Christmas! :) I'm new here but feel I'm gonna learn a lot from all you smart people! Hoping you can help me with a little dilemma please... I want to be able to return 4 names in B4, D4, F4 & H4, this detail will be from sheet 2 and will be based on the number entered in B2...