Thanks Mr. Logit,
I tried, but couldn't find what I am looking for, if you could help I wd appreciate.
Thanks,
Thanks Mr. Logit,
I tried, but couldn't find what I am looking for, if you could help I wd appreciate.
Thanks,
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.
Thank you in advance,
Raaj.
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.
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.
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.
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.
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.
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
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.
Hope i made it clear.
thanks,
raaj.
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.
Re: Deleting preceding Zero
Yes even this worked, thank you so much
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.
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?
Please help.
Raaj.
Re: Deleting preceding Zero
they are in separate cells, thanks
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"]
[TD="class: xl63, width: 80"]P00000001,
[TABLE="width: 80"]
[TD="class: xl63, width: 80"]P00000002
[TABLE="width: 80"]
[TD="class: xl63, width: 80"]P00000100
[TABLE="width: 80"]
[TD="class: xl63, width: 80"]P00020101
[TABLE="width: 80"]
[TD="class: xl63, width: 80"]P00030000
Raaj.
[/TD]
[/TABLE]
[/TD]
[/TABLE]
[/TD]
[/TABLE]
[/TD]
[/TABLE]
[/TD]
[/TABLE]
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.
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.
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?
pls share your thoughts.
thanks