$$Excel-Macros$$ Macro for data indexing

2014-04-02 Thread Deepak Rawat
Dear friends, I attached a sheet it has a data set A I need to convert data into data set B for cleaning (value is comma separated) after cleaning and unique i have to put that data into same format as data set A i.e. comma separated on appropriate serial number i have a huge data set to

$$Excel-Macros$$ All text box need to be enter

2014-04-02 Thread Rameshwari
Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information then check for textbox4, if filled with information then check for textbox5. If all textbox 3, 4 5 are filled with information then go to remaining process.

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

2014-04-02 Thread Ravinder
Try this file -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Wednesday, April 02, 2014 12:22 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

2014-04-02 Thread amar takale
Dear Ravinder Perfect,You are done it. I am really thankful for its wonderful coding. I have some other query regarding this issue topic (If you have sufficient time regarding my query) Single Excel sheet more than 2 tables 1) I will create button click then automatic table copy

RE: $$Excel-Macros$$ Macro for data indexing

2014-04-02 Thread Ravinder
pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deepak Rawat Sent: Wednesday, April 02, 2014 11:51 AM To: excel-macros Subject: $$Excel-Macros$$ Macro for data indexing Dear friends, I attached a sheet it has a data set A I need to

RE: $$Excel-Macros$$ Need macro for repetative formatting

2014-04-02 Thread Ravinder
Provid any data and your 10 steps which u want to do after download data from software From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Suyog Kulkarni Sent: Tuesday, April 01, 2014 7:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

$$Excel-Macros$$ Re: All text box need to be enter

2014-04-02 Thread Rameshwari
Dear Team, Forget to attached excel sheet. Please help on this Regards, Rameshwari :) On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari wrote: Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information

Re: $$Excel-Macros$$ Re: All text box need to be enter

2014-04-02 Thread Ganesh N
Hi Rameshwari, Please find the attached file. Regards, Ganesh N On Wed, Apr 2, 2014 at 3:41 PM, Rameshwari rameshwarish...@gmail.comwrote: Dear Team, Forget to attached excel sheet. Please help on this Regards, Rameshwari :) On Wednesday, April 2, 2014 10:26:11 AM UTC+4, Rameshwari

Re: $$Excel-Macros$$ Macro for data indexing

2014-04-02 Thread Deepak Rawat
hi thanx for your reply but its not working correctly On Wed, Apr 2, 2014 at 2:42 PM, Ravinder ravinderexcelgr...@gmail.comwrote: pfa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat *Sent:* Wednesday, April 02, 2014 11:51 AM

Fwd: $$Excel-Macros$$ Show links which to other Data source

2014-04-02 Thread Ashish Bhalara
-- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com Date: Tue, Apr 1, 2014 at 1:23 PM Subject: $$Excel-Macros$$ Show links which to other Data source To: excel-macros@googlegroups com excel-macros@googlegroups.com Dear experts, My workbook containing large no.

Re: $$Excel-Macros$$ Macro for data indexing

2014-04-02 Thread Deepak Rawat
Dear Ravinder, i was making mistake in selection but its working correct, kindly give me a code to reverse it my point is after doing all words in one line i could make them unique but after that i need to put in that form again Regards, Deepak Rawat On Wed, Apr 2, 2014 at 2:42 PM, Ravinder

Re: $$Excel-Macros$$ Re: All text box need to be enter

2014-04-02 Thread rameshwari shyam
Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer the data to excel sheet all textbox need to be blank. as this very confidential data of user not suppose to be duplicate. Please help. Regards, Rameshwari :)

Re: $$Excel-Macros$$ Re: All text box need to be enter

2014-04-02 Thread rameshwari shyam
Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer the data to excel sheet all textbox need to be blank. as this very confidential data of user not suppose to be duplicate. Please help. Regards, Rameshwari :)

Re: $$Excel-Macros$$ Re: All text box need to be enter

2014-04-02 Thread Ganesh N
Hi rameshwari, Please find the updated one. Regards, Ganesh N On Wed, Apr 2, 2014 at 4:18 PM, rameshwari shyam rameshwarish...@gmail.comwrote: Dear Ganesh, Thank you very much for quick reply. Once enter the data in all textbox after that hit the submit button. and after transfer the

$$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

2014-04-02 Thread Rashid Khan
Dear All, I am using Excel 2010. I have attached a sample file with my problem. Please see before and after Any macro help would be appreciate. Regards Rashid -- 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

$$Excel-Macros$$ Help Required Urgent

2014-04-02 Thread Neeraj Chauhan
Dear experts, Kindly find the attached sheet. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- 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

Re: $$Excel-Macros$$ Re: All text box need to be enter

2014-04-02 Thread rameshwari shyam
Dear Ganesh, Here active cell will be different, data need to fill as per textbox3 value in colostrum A first empty row textbox4 value in column B first empty row textbox5 value in column C first empty row Please help Regards, Rameshwari :) On Wed, Apr 2, 2014 at 3:04 PM, Ganesh N

RE: $$Excel-Macros$$ Help Required Urgent

2014-04-02 Thread Ravinder
PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Neeraj Chauhan Sent: Wednesday, April 02, 2014 4:43 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required Urgent Dear experts, Kindly find the attached sheet. _

RE: $$Excel-Macros$$ Help Required Urgent

2014-04-02 Thread Neeraj Chauhan
Thanks Ravinder From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Wednesday, April 02, 2014 5:11 PM To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros$$ Help Required Urgent PFA From: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Macro for IF AND condition

2014-04-02 Thread Renata Torquato
Olá Basole, obrigada pela resposta. Ainda não é isso Rs* Acontece que a célula somente deve mudar para o status DELAYED caso ela possua o status ON TRACK *E SE *a data do deadline for menor que a data atual (Se for igual o status deve continuar ON TRACK). Caso eu manualmente mude o status

Re: $$Excel-Macros$$ Show links which to other Data source

2014-04-02 Thread ashish koul
Sub find_links() Dim extlinks Dim j As Long, k As Long Dim wkb As Workbook Dim rng As Range, cl As Range Dim links1 As String Dim wk As Worksheet Set wkb = Workbooks.Add wkb.Sheets(1).Range(a1).Value = Sheet Name wkb.Sheets(1).Range(b1).Value = Cell Address

Re: $$Excel-Macros$$ Convert PDF to Excel - single file with 12000 pages

2014-04-02 Thread Ricardo®
Pls. share your PDF file, so I can adjust the code in this format. Regards, Basole. 2014-04-02 1:37 GMT-03:00 Abhishek Jain abhishek@gmail.com: I tried saving the PDF as Text and importing it in Excel, it didn't work. Do you have a sample macro or something that I can try? Thanks.

Re: $$Excel-Macros$$ Macro for IF AND condition

2014-04-02 Thread Renata Torquato
Olá, boa tarde. Muito obrigada. Vou testar no arquivo original para ver como roda. Muito obrigada. Att. Em quarta-feira, 2 de abril de 2014 15h19min18s UTC-3, Basole escreveu: Olá Renata boa tarde, Veja agora no anexo, se entendi o que voce quer. Saudações, Basole.

Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

2014-04-02 Thread Bipin Singh
Rashid Sir, Hope attached will help? On Wed, Apr 2, 2014 at 4:39 PM, Rashid Khan prkha...@gmail.com wrote: Dear All, I am using Excel 2010. I have attached a sample file with my problem. Please see before and after Any macro help would be appreciate. Regards Rashid -- Are you

$$Excel-Macros$$ Re: Macro for data indexing

2014-04-02 Thread João
Hello, what I propose will involve Word (or any other word processor) besides excel but will work pretty fast: Copy the column with the data to Word, paste it as unformatted text. Run a replacement searching for commas and replacing them with ^p for paragraph. Copy the data to excel and it

$$Excel-Macros$$ Strange .visble Issue

2014-04-02 Thread ydoubleuz
Hi All, Chanced upon a strange error and unable to find any threads on it. Private Sub SWS_CB_Click() 'SWS_CB is a checkbox while SWS_LB is a listbox If Sheet2.SWS_CB.value = True Then Sheet2.SWS_LB.Visible = True 'Sheet2.SWS_LB.Enabled = True Else Sheet2.SWS_LB.Visible = False

$$Excel-Macros$$ Validation on button click

2014-04-02 Thread Rupesh Patil
Hello Experts, I need your kind, I have attache sheet with my requirement, Please find in attachment. -- Thanks and Regards, Rp. -- 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 @

RE: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values

2014-04-02 Thread Ravinder
pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bipin Singh Sent: Thursday, April 03, 2014 1:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy Data from next Column and Repeat Paste as per the Values Rashid Sir, Hope

Fwd: $$Excel-Macros$$ Show links which to other Data source

2014-04-02 Thread Ashish Bhalara
-- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com Date: Wed, Apr 2, 2014 at 4:10 PM Subject: Fwd: $$Excel-Macros$$ Show links which to other Data source To: excel-macros@googlegroups com excel-macros@googlegroups.com -- Forwarded message --

Re: $$Excel-Macros$$ All text box need to be enter

2014-04-02 Thread ashish koul
please share the sample file On Wed, Apr 2, 2014 at 11:56 AM, Rameshwari rameshwarish...@gmail.comwrote: Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information then check for textbox4, if filled with information

$$Excel-Macros$$ Arrow solution

2014-04-02 Thread amar takale
Dear Expert team I required arrow solution in excel for UP Down Constant.Pls see attached sheet. Regards Amar -- 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