Re: $$Excel-Macros$$ Lookup

Hi all.. i have a doubt in excel qt General: Ex: in one folder its have five(5) different work book are there like "a',"b",c,d,e" and each work it has 3 sheets same data . how to get page setup in all work book at the same thanking you -- Join official Facebook page of this forum

$$Excel-Macros$$ Re: VBA & vlookup issue

Both files in same server, but I wish can add the path but use a cell value in worksheet "Data_Set" on the Publish.xlsm file Below blue color script is a new add modify, but still come out error 1004 C2 = \\Server\Plan Delivery D2 = [WSO_Record]Record Private Sub Worksheet_Change(ByVal Target As

$$Excel-Macros$$ Re: dear experts is there any solution for pick the step value in certain table

Hi Renuka, Please find one more solution from my side : =INDIRECT(CHAR(65+ROW(A1))&ROW(B3)-1) Regards Prince On Monday, November 19, 2012 10:35:49 PM UTC+5:30, renuka chari wrote: > > Dear experts, > is there any solution for pick the step value in certain table? > > please see above attac

$$Excel-Macros$$ Re: VBA & vlookup issue

both files is under same server, but if i want set give a path value in Publish.xlsm, in worksheet "Data_Set", C2 is path and D2 is target file and sheet name to connect the blue color script if i add will solve the issue? C2 = \\Server\Plan Delivery D2 = [WSO_Record]Record Private Sub Workbo

$$Excel-Macros$$ Re: VBA & vlookup issue

thx your reply, here is the excel file, is use Publish.xlsm connect WSO_Record.xls -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem

Re: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table

Hi Renu, Please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Tue, Nov 20, 2012 at 10:20 PM, renuka chari wrote: > hi Excel beginner, > i don't know your name? > but you gave me a wonderful solution > thanks allot. > but is there any easy formula f

Re: $$Excel-Macros$$ Duplicate line based on column

Hi Viswanathan, Pls find the attachment. -- *Regards,* * * *Excel Beginner* * * On Wed, Nov 21, 2012 at 2:43 AM, Viswanathan Yoganathan < viswanathan.yoganat...@asia.xchanging.com> wrote: > HI, > > ** ** > > In the attached excel, I need to remove the duplicate li

Re: $$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table

Hi! jeet singh, Thanks i am expecting this only thanks a lot On Wednesday, 21 November 2012 11:20:48 UTC+5:30, jeet singh wrote: > > PFA > > On Tue, Nov 20, 2012 at 10:20 PM, renuka chari > > wrote: > >> hi Excel beginner, >> i don't know your name? >> but you gave me a wonderful solution...

Re: $$Excel-Macros$$ Dynamic calendar quiz : There is a prize for the winner. *

SUBMITTED On Mon, Nov 19, 2012 at 12:32 PM, Deba Ranjan wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (drdeva...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Re: Please help - How to export specific range by ID to other excel file.

My apologies Anoop, I hope you can understand my code, I tried to comment it at key locations. I attached a workbook the second go around. On Tuesday, November 20, 2012 9:38:32 PM UTC-5, Enrique Martin wrote: > It's better to attach the file and put you query there. > No one gonna study this co

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

Glad it worked for you. On Tuesday, November 20, 2012 1:29:45 PM UTC-5, Mangesh wrote: > Thank you so much Natron. > > You have made my work very easy. > > Thanks again. > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accura

Re: $$Excel-Macros$$ Re: Mandatory Field

Thanks prince and Natron On Tue, Nov 20, 2012 at 9:37 PM, Prince wrote: > Hi Shrini, > > > I think without macro it is not possible to do as formulas can not control > objects and a workbook is an object. But you can do one thing by using > conditional formatting you can intimate user to fill th

$$Excel-Macros$$ Re: VBA & vlookup issue

Hi Teow, Can you ple share your Both WorkBook eg. WSO_Record.xls and the one inwhich ur writing formula. Regards Prince On Wednesday, November 21, 2012 4:34:54 PM UTC+5:30, Teow wrote: > > > > when i use C:\test\[WSO_Record.xls]Record, the script can run propriety, > but if change to network p

Re: $$Excel-Macros$$ VBA & vlookup issue

Dear teow, can u share a workbook with us?? Regards, Gawli Anil On Wed, Nov 21, 2012 at 4:34 PM, Teow wrote: > > > when i use C:\test\[WSO_Record.xls]Record, the script can run propriety, > but if change to network path " & ThisWorkbook.Path & > "\[WSO_Record.xls]Record, i will get error 1004

$$Excel-Macros$$ VBA & vlookup issue

when i use C:\test\[WSO_Record.xls]Record, the script can run propriety, but if change to network path " & ThisWorkbook.Path & "\[WSO_Record.xls]Record, i will get error 1004, what is the error in my script? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 And Ta

$$Excel-Macros$$ Request Macro for Merge Text file

Dear All, Please find below is my request to create excel macro. I have a list of files in local directory and file list located in A column and need to merge text file based on the B column listed files. A1---B1 C:\1.txt --- C:\Merge\1.txt C:\2.txt --- C:\3.txt --- C:\4.tx

Re: $$Excel-Macros$$ Event - Worksheet Change

solved your query now  --- On Mon, 11/19/12, Raj Mahapatra wrote: From: Raj Mahapatra Subject: $$Excel-Macros$$ Event - Worksheet Change To: excel-macros@googlegroups.com Date: Monday, November 19, 2012, 11:15 PM Dear Friends, kindly help out on below macro,  i am not able to get output. I Wa