$$Excel-Macros$$ Double click event for different column

2013-07-29 Thread SAJID MEMON
Dear Experts, I have attached my file, here different column double clicking and data should paste in different columns, I have done only in one column and other is unable to do. please co-operate me to complete my assignment. Awaiting your positive response Regards Sajid Memon

$$Excel-Macros$$

2013-07-29 Thread SAJID MEMON
Dear Experts, I have attached my file, here different column double clicking and data should paste in different columns, I have done only in one column and other is unable to do. please co-operate me to complete my assignment. Awaiting your positive response Regards Sajid Memon

Re: $$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

2013-07-29 Thread Don Barton
vba, thanks for your suggestion, which will work fine in formula. De Premor - the code works exactly as designed with our barcode scanner! Our Blood Bank supervisor is impressed! Thanks you so much for your quick reply and expert help. Don On Mon, Jul 29, 2013 at 12:37 PM, De Premor wrote:

Re: $$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

2013-07-29 Thread De Premor
try this code Sub trunkit() Dim Ctx As Range 'We use this method to get dynamic Record count in C Column For Each Ctx In Range("C2:" & Cells(Range("C:C").Rows.Count, 3).End(xlUp).Address) If Right(Ctx, 2) = "00" Then 'Replace "=" sign, from removed 00 string

Re: $$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

2013-07-29 Thread vba
Hey You can do do with formula =MID (A1, 2, LEN (A2)-3) HTH//Cheers On 29 Jul 2013 23:48, "Don Barton" wrote: > Hi Sam, > When the barcode is scanned it reads in alphnumerics and symbols. The > only symbol we have to worry about is the "=" sign at the beginning. In the > example above I just

Re: $$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

2013-07-29 Thread Don Barton
Hi Sam, When the barcode is scanned it reads in alphnumerics and symbols. The only symbol we have to worry about is the "=" sign at the beginning. In the example above I just asked about the "00" at the end. If I can get the code for the "00", I should be able to figure out the code for the "=" a

Re: $$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

2013-07-29 Thread Sam Mathai Chacko
Are the entire code only numerics, or are they alpha numeric? On Mon, Jul 29, 2013 at 10:44 PM, Don Barton wrote: > Greetings, > We have a scanner we use to scan a barcode for blood units for a hospital > into an Excel spreadsheet. The scanner reads the entire barcode, but we > want to remove

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2013-07-29 Thread vba
Welcome back DP :) Its been pleasure having you. Cheers On 29 Jul 2013 22:47, "De Premor" wrote: > just remember, that i also not yet introduce my self :( > > then let me introduce my self > You can call me *De* *Premor* and i am working in Network and > Infrastucture Division at intermediate

Re: $$Excel-Macros$$ Occurrence of a Denominaton

2013-07-29 Thread vba
Hey Use this formula: =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1)) Where A2:A10 is range of your data. Thanks!! On Mon, Jul 29, 2013 at 10:27 PM, Kush Shama wrote: > Dear Team > > I have a Query. Let says I have a column in which multiple denominations > are written. for example, A1 contains 1000,

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2013-07-29 Thread De Premor
just remember, that i also not yet introduce my self :( then let me introduce my self You can call me *De* *Premor* and i am working in Network and Infrastucture Division at intermediate Palm and Oil Mills in beautiful Borneo, Indonesia, i love to learn programming in my spare time since i sti

$$Excel-Macros$$ VBA remove character at beginning and end of string (cell)

2013-07-29 Thread Don Barton
Greetings, We have a scanner we use to scan a barcode for blood units for a hospital into an Excel spreadsheet. The scanner reads the entire barcode, but we want to remove "00" at the end of the scanned string. If there isn't "00" at the end, make it null cell. We are using the correct symbo

$$Excel-Macros$$ Occurrence of a Denominaton

2013-07-29 Thread Kush Shama
Dear Team I have a Query. Let says I have a column in which multiple denominations are written. for example, A1 contains 1000, a2 contains 100 and A3 contains 500. Lets say I have 140 Such Cells in same column A. If I wish to count how many have a particular denomination, or the number of occurren

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2013-07-29 Thread vba
Hey Welcome on the board. On 29 Jul 2013 22:18, "Don Barton" wrote: > Greetings, > > My name is Don Barton and I am a laboratory informaticist at a small > hospital in beautiful Colorado, USA. I've done a lot of work in Access, > but am needing to learn VBA in Excel. Look forward to interactin

$$Excel-Macros$$ Re: Introduce Yourself !!

2013-07-29 Thread Don Barton
Greetings, My name is Don Barton and I am a laboratory informaticist at a small hospital in beautiful Colorado, USA. I've done a lot of work in Access, but am needing to learn VBA in Excel. Look forward to interacting with you all. Don -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

2013-07-29 Thread Ashish Kumar
Dear Prabhu, THANKS A LOT. On 29 July 2013 20:41, Prabhu Pinky wrote: > Sumif - used to sum the range by checking single condition. > Sumifs - used to sum the range by checking multiple conditions. > > Countif - used to count the range by checking single condiyion. > Countifs - used to count th

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

2013-07-29 Thread Ashish Kumar
Dear Rajasekhar, THanks On 29 July 2013 21:00, Rajasekhar Praharaju wrote: > Hi Ashish, > > Just go through this link... you have good examples... > > http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/ > > Thanks, > Raj > > > On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky wrote: > >

Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-29 Thread Secret Shot
Put "=" sign in cell A2 itself at the bagining of the text... :P On Sun, Jul 28, 2013 at 1:46 PM, De Premor wrote: > create defined name in example : "*Eval**A2*" that referring to > =EVALUATE(A2) > > Then in some cell in that sheet, just type *=EvalA2** > * > > > Pada 28/07/2013 14:59, xlstim

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

2013-07-29 Thread Rajasekhar Praharaju
Hi Ashish, Just go through this link... you have good examples... http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/ Thanks, Raj On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky wrote: > Sumif - used to sum the range by checking single condition. > Sumifs - used to sum the range by

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

2013-07-29 Thread Prabhu Pinky
Sumif - used to sum the range by checking single condition. Sumifs - used to sum the range by checking multiple conditions. Countif - used to count the range by checking single condiyion. Countifs - used to count the range by checking multiple conditions. On Jul 29, 2013 8:28 PM, "Ashish Kumar" w

$$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

2013-07-29 Thread Ashish Kumar
Dear seniors, How can we use sum & sumifs , countif & countifs. and what is the diffrence between. pls explain with formula and example. pls help me. thanks Ashish -- 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

Re: $$Excel-Macros$$ need vlookup formula help

2013-07-29 Thread De Premor
Try to use this in cell B2 *=VLOOKUP($A2,INDIRECT("'" &B$1 & "'!$B$2:$R$302"),16,FALSE)** * Copy it down Pada 29/07/2013 18:22, Dhaval Shah menulis: here with attach a file for reference On Mon, Jul 29, 2013 at 4:49 PM, Dhaval Shah > wrote: Friends ,

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-29 Thread De Premor
ups sorry, please ignore my last email, i've replied a wrong topic My bad :-\ Pada 29/07/2013 19:37, De Premor menulis: Try to use this in cell B2 *=VLOOKUP($A2,INDIRECT("'" &B$1 & "'!$B$2:$R$302"),16,FALSE)** * Copy it down Pada 27/07/2013 20:44, Puttu * menulis: Experts your assistance is

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-29 Thread De Premor
Try to use this in cell B2 *=VLOOKUP($A2,INDIRECT("'" &B$1 & "'!$B$2:$R$302"),16,FALSE)** * Copy it down Pada 27/07/2013 20:44, Puttu * menulis: Experts your assistance is much appreciated. On Sat, Jul 27, 2013 at 4:55 PM, Puttu * > wrote: Hi Experts, Ne

Re: $$Excel-Macros$$ Re: I appreciate your help :-)

2013-07-29 Thread P.VIJAYKUMAR
Respected Sonu, Please look into the following links for explanation.There are also other links on the net, but these may help you undersatnd OFFSET function better. http://www.myonlinetraininghub.com/excel-offset-function-explained http://www.youtube.com/watch?v=kvXToxeiS6Y http://chandoo.org/wp/

$$Excel-Macros$$ Re: I appreciate your help :-)

2013-07-29 Thread Sonu Kumar
Hello Ayush, I just want to know the functionality of offset. How to use it. Note - I am able to use Vlookup, index, match. But unable to understand the offset option. Please guide me asap. Thanks, Sonu On Thursday, March 7, 2013 9:36:29 PM UTC+5:30, Ayush Jain wrote: > > Dear members, > > Le

Re: $$Excel-Macros$$ Copy Data from Reference file to Master file

2013-07-29 Thread Puttu *
please help me on the macro.. On Sun, Jul 28, 2013 at 10:14 AM, Puttu * wrote: > Any updated on the macro team.. > > > On Sat, Jul 27, 2013 at 7:14 PM, Puttu * wrote: > >> Experts your assistance is much appreciated. >> >> >> On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wr

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

2013-07-29 Thread De Premor
This is the sample code, you can set it up in ExpDate variable Private Sub Workbook_Open() Dim ExpDate As Date ExpDate = #8/17/2013 10:00:00 AM# If Now > ExpDate Then ThisWorkbook.Close MsgBox "This workbook will expired at " & Format(ExpDate, "dd hh:mm:ss AM/PM") End

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

2013-07-29 Thread Kannan Excel
thanks thanks a lot i am really happy. On Mon, Jul 29, 2013 at 2:13 PM, De Premor wrote: > sorry little mistake there, try new attached > > > On 29/07/2013 15:37, Kannan Excel wrote: > > how to make this??? > > can u send code??? > > and if i type user and pswd means, permissio

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

2013-07-29 Thread Kannan Excel
can u do me a favor??? i don't want user and pswd... i want vb coding for expire date and time pls send that code how to set date and time to expire On Mon, Jul 29, 2013 at 1:16 PM, De Premor wrote: > try this attached file > > user, pass, and expiration date defined in a sheet > > > On 29/0

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

2013-07-29 Thread Kannan Excel
how to make this??? can u send code??? and if i type user and pswd means, permission granted or user has expired message only appear... excel sheet not open... On Mon, Jul 29, 2013 at 1:16 PM, De Premor wrote: > try this attached file > > user, pass, and expiration date defined in a sheet

Re: $$Excel-Macros$$ how to make a file expire after a period of time.

2013-07-29 Thread De Premor
try this attached file user, pass, and expiration date defined in a sheet On 29/07/2013 13:05, Mangesh Vimay wrote: Thanks for asking this query. Appreciate your mind !!! And also thanks De Pemor for the solution. Have a great day all !!! On 7/29/13, Kannan Excel wrote: Hi, I want to set