# Posts by raajnabriz

• ## Excel Formula Help

Thanks Mr. Logit,

I tried, but couldn't find what I am looking for, if you could help I wd appreciate.

Thanks,

• ## Excel Formula Help

Dears,

I have 2 sheets in a workbook viz; Sheet1 and Sheet2, i need an excel formula if possible to choose the price from Sheet2 when i input a code like 010001, 010900, 011500, 020100, 030200 etc in Sheet1 column "U"
There are at least 5000 cells in Sheet2 with price and the corresponding codes eg: Sheet2 - column A has codes as shown above, Column C has its related price, so whenever i put a code in Sheet1 Column U, the formula should search the price in Sheet2 and paste it in Sheet1 against the same code mentioned in Sheet1 in Column Y.

Raaj.

• ## Excel formula to copy row from one sheet to another if a condition is met in the main

Re: Excel formula to copy row from one sheet to another if a condition is met in the

Hi Alan,

That ws a silly mistake from me, i corrected it and now its working gr8.

thank u so much for your time and help. God Bless.

Raaj.

• ## Excel formula to copy row from one sheet to another if a condition is met in the main

Re: Excel formula to copy row from one sheet to another if a condition is met in the

Hi Alan,

i tried the new macro, but still its duplicating, therefore i am attaching the excel sheet for your review.

thanks
raaj.

• Book1.xls

• ## Excel formula to copy row from one sheet to another if a condition is met in the main

Re: Excel formula to copy row from one sheet to another if a condition is met in the

Thanks Alan, i will check and come back.

raaj.

• ## Excel formula to copy row from one sheet to another if a condition is met in the main

Re: Excel formula to copy row from one sheet to another if a condition is met in the

Dear Alan,

i ran the macro just once and it copied twice, but i have to run the macro continually as and when the other rows updates to as "RECEIVED", please advice. if there is any update option it wud be much better.

thanks,
raaj.

• ## Excel formula to copy row from one sheet to another if a condition is met in the main

Re: Excel formula to copy row from one sheet to another if a condition is met in the

Dear AlanSidman

Your help turned out gr8 and the job is almost perfect but for one thing, there is duplication of the data in the summary sheet
i mean it is taking each row "RECEIVED" twice, for example in each of the worksheet "RECEIVED" is mentioned only 208 times, but in the summary sheet the total number copied is 416 which is twice of the actual, pls let me know where the error is. But overall the VB is perfect.

Thanks once again.
Raaj.

• ## Excel formula to copy row from one sheet to another if a condition is met in the main

Re: Excel formula to copy row from one sheet to another if a condition is met in the

hi,

please find attached a copy of the data as required, though i hv only 5 columns in there but the original consists of 15 columns, the important being Cell D, wherein "RECEIVED" will be mentioned upon which the entire row should be transferred to a common sheet.

thanks
raaj

• Book1.xlsm

• ## Excel formula to copy row from one sheet to another if a condition is met in the main

Re: Excel formula to copy row from one sheet to another if a condition is met in the

hi,
i have 15 sheets and a common sheet, i want a formula to copy the entire row wherein "RECEIVED" is mentioned in those 15 sheets to the common sheet, and yes there are more columns in those 15 sheets, so if in each cell of column D in each of those 15 sheets is mentioned as "RECEIVED" then the entire row should be automatically copied to the common sheet.

thanks,
raaj.

• ## Excel formula to copy row from one sheet to another if a condition is met in the main

Hi,

i have a workbook wherein there are almost 15 sheets with different sheet names e.g SCHOOL, COLLEGE, UNIVERSITY ETC

Column A is for Serial No.
Column B is for Contact No.
Column C is for Name
Column D is for Status

whenever i type "RECEIVED" in Column D, i want that entire row to be copied to a new sheet from each of the above sheets mentioned above.

Your expert help will be appreciated.
Thanks,
Raaj.

• ## Deleting preceding Zero

Re: Deleting preceding Zero

Yes even this worked, thank you so much

• ## Deleting preceding Zero

Re: Deleting preceding Zero

Thanks All,

i used this Excel formula: =RIGHT(a1, LEN(a1)-1) and got the required answer.

Thanks anyway for all your efforts.

Raaj.

• ## Deleting preceding Zero

Re: Deleting preceding Zero

i used your VB code and put the =contractCode(A2) in B2, it give me #Name?

What could be the mistake?

Raaj.

• ## Deleting preceding Zero

Re: Deleting preceding Zero

Thanks KjBox

I will try this out.

Raaj.

• ## Deleting preceding Zero

Re: Deleting preceding Zero

they are in separate cells, thanks

• ## Deleting preceding Zero

Hi,

i have more than 10,000 pharmacy codes starting like below, i need a formula to erase all the zeros and the alphabet before the number but not the zero after the number eg: 1, 100, 20101, 3000 etc etc. Thanks for your help in advance. [TABLE="width: 80"]

[tr]

[TD="class: xl63, width: 80"]P00000001,
[TABLE="width: 80"]

[tr]

[TD="class: xl63, width: 80"]P00000002
[TABLE="width: 80"]

[tr]

[TD="class: xl63, width: 80"]P00000100
[TABLE="width: 80"]

[tr]

[TD="class: xl63, width: 80"]P00020101
[TABLE="width: 80"]

[tr]

[TD="class: xl63, width: 80"]P00030000

Raaj.
[/TD]

[/tr]

[/TABLE]
[/TD]

[/tr]

[/TABLE]
[/TD]

[/tr]

[/TABLE]
[/TD]

[/tr]

[/TABLE]
[/TD]

[/tr]

[/TABLE]

• ## How to write 2 codes in Private Sub Workbook_Open()

Re: How to write 2 codes in Private Sub Workbook_Open()

thanks Grimes0332

• ## How to write 2 codes in Private Sub Workbook_Open()

Re: How to write 2 codes in Private Sub Workbook_Open()

hi, i checked it on google and found out that you are right.
its really bad that there is password hacking technique when a person has put so much effort to build the code and it is hacked so easily.

• ## How to write 2 codes in Private Sub Workbook_Open()

Re: How to write 2 codes in Private Sub Workbook_Open()

"in 5 seconds", that requires a professional, thank God v dont have any

thanks.

• ## How to write 2 codes in Private Sub Workbook_Open()

Re: How to write 2 codes in Private Sub Workbook_Open()

"Useful against people who don't know VBA, useless against anyone else"

hi, just one query

i have locked the VBA code with password, then how it will be useless, will a person knowing VBA can bypass it?