$$Excel-Macros$$ VBA Date Picker xls

Dear all Experts, PFA with all detailed. Regards Amar T -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Po

$$Excel-Macros$$ plz add me

Dear sir, plz add me thanks regards LAKSHMAN -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

The trick is that: when the third digit of the batch number from right to left is greater than zero, adds the letter "x" to the batch number. When the code in ascending order organizes the "x + BN" is last. 'Pro Please change this line in your code below: Cells(i, 4) = Replace(orig2, orig2, Mid

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

Thanks a LOT Basole, That did the trick! :D Tom On Tuesday, January 14, 2014 1:05:19 PM UTC, Basole wrote: > Dear Tom, > Test attachment. > For this case, I think this solved, let's see the next chapters. > > Basole > > > > Em quarta-feira, 8 de janeiro de 2014 11h18min26s UTC-2, Tom Yaxley >

$$Excel-Macros$$ SUMPRODUCT: #VALUE ERROR

I'm looking for some help with one of the components of a SUMPRODUCT formula that is causing the formula to error: Starting in A1: alpha137 beta224 gamma492 in A4: 49 in A5: 2 The idea is for one of the components of the SUMPRODUCT formula to look for a string (in A4) in each cell in the

$$Excel-Macros$$ Removing a cell after being highlighted for a few seconds

i have an excel sheet in which i have two rows of data which will be filled by the customers; i need to highlight duplicates in the data entry by the customers. Is it possible to remove the highlighted cells after a span of five seconds. Can some member help me with the code for removing the format

$$Excel-Macros$$ Re: Data from one column to another without blanks but still in order?

Basole, Thanks for this! The numbers can be anywhere from 001-400, so will always be 3 digits. The ending will always be K but the beginning could be nothing (i.e. just ###K) or it could be B (i.e. B##K) or finally it could be TN (i.e. TN###K) Hope that helps Thanks Tom On Monday, January 13