HI ,
I have a list of IDs number like S0001234AA to S0001234AZ from top to bottom in Column A .Actually the list consist of many Raw data From S0001234 and other IDs with additional alphabaet behind Such As S0001234AA-AZ , S0005678AA-AZ etc..
Now what I would like to do is using a vlookup...
HI Shrivallabha..ok..thanks I will check it in office but this whole workbook consist of 32 modules..(this code is in module 7 and i actuallly just change the FILEsearch command to the one you rewrote for me..Im sure i forgot to do something...
Hi all,
I know that if I had used Application.filesearch in excel 2003 and I upgrade to excel 2010 , the command will not works(Runtime error 445)
I am totally new to Macro but I knows how to click debug and get a glimpse of how the code looks like..Could someone please teach me how do I...
hi bobhc and HUI
the problem is our workplace defualt browser is an IE.The situation is that we could download data from the IE and there is no "Save as" , only "open"..And file format is supposed to be *.csv on excel workbook.Instead it straight away shows all the data in the Explorer page...
Hi all,
I've search online for many means other than to editing the registry but is here any way to allows data to be download and opened in Excel 2010 instead of the internet explorer.
I could do it in Excel 2003 but not 2010 and I can't and are quite unwilling to edit the registry as it is...
Hi , i would like to assign a macro to run everyday at, lets say , 8:00am.
Is it possible that I do not open the workbook and yet the macro is automatically run and save to filename_Date?
Hi Luke,
you're right.
When I mention that "This formula works only if the start date and end is only a difference of 1 day.If the lot took more than 1 day, for example: 8/13/11 7:25 to 8/15/11 8:25
the results i get will be 14th AUg instead'
THIS IS actually correct.I make myself...
Hi Luke.
thats really fast of you.. :)
Yes..thats about it.The formula should be =INT(C2-TIME(8,5,0))was correct because i want the END date after 8.05am .
My fault for not showing you th correct date/time format.
It should be 8/13/11 7:25
Last thing.This formula works only if the start...
Hi Luke,
thanks for the reply but unfortunately,thats not my aim.
column A Column B Column C Column D
9th Aug 9.35am 10th Aug 7.35am Lot A 200pcs
9th Aug 7.35am 10th Aug 8.35am Lot B 1500pcs
10th Aug 9.35am 10th Aug 11.35am Lot C...
Hi all, first post here so pls pardon me if my question is not clear.
I'm in production planning and i would like to see the output of the production from , lets say 8.05am of 10th Aug to 8.05am of 11st Aug.
The data is like this where the data i get should stop at 8.05am which means it...