Re: $$Excel-Macros$$ Macro to copy from one worksheet to another if a cell value matches

Sorry mate. I only realized just now that you have replied on my e-mail. I have gone through the both attachment and have some questions: 1. Column with heading "JIRA Key Details/Next Step(s)" is not in Source file. 2. No Data in source file for "Jira case owner column. 3.There are more than one

Re: $$Excel-Macros$$ Macro to copy from one worksheet to another if a cell value matches

That can be done just attach a sample file showing desired output. On Tue, Apr 15, 2014 at 12:03 AM, vaibhav garg wrote: > Hi Ayush, > > > I want to copy certain columns from a source sheet to a target sheet > based on a unique identifier than is present in both the sheets. > Please help me ,

$$Excel-Macros$$ Macro to copy from one worksheet to another if a cell value matches

Hi Ayush, I want to copy certain columns from a source sheet to a target sheet based on a unique identifier than is present in both the sheets. Please help me , its highly urgent. regards vaibhav -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:O

Re: $$Excel-Macros$$ Macro for copying from a notepad and creating a record in excel

can u share how your output look likes On Thu, Apr 3, 2014 at 10:25 PM, Subhra Sardar wrote: > > > I am new to VBA and I need a little help with VBA.The file is attached. > > As you can see below *column B *(EVENT TYPE) there is a field named *JOB* and > below the field *JOB* there is a field n

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

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$$ Macro for IF & AND condition

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 para

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

wrote: > 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

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

> *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 convert data into data set B for cleaning (value is comma > separated) > > > > &

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

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

$$Excel-Macros$$ Macro for data indexing

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 clea

$$Excel-Macros$$ macro to insert a range based on cell value

Hello I am stumped. I need a macro that will insert a range of cells based on criteria of another cell. I have attached a sample spreadsheet. Can anyone help me figure this out? TYIA, Joy -- 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) ! Jo

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

Ashish - You are a very talented star! The code works perfectly. Thank you so much. Michael On Sat, Mar 29, 2014 at 12:47 PM, ashish koul wrote: > Sub test() > Dim filenm As String, folderpath As String > folderpath = "C:\Documents and Settings\Ashish Koul\Desktop\sample > files\" >

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

can u share a sample file? On Sun, Mar 30, 2014 at 9:44 PM, Renata Torquato wrote: > Thanks. > > That's exactly what I tried before but it doesn't work ... =/ > > Em domingo, 30 de março de 2014 12h29min52s UTC-3, ashish escreveu: >> >> Sub test() >> >> With Sheets("Sheet1") >> If .R

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

Thanks. That's exactly what I tried before but it doesn't work ... =/ Em domingo, 30 de março de 2014 12h29min52s UTC-3, ashish escreveu: > > Sub test() > > With Sheets("Sheet1") > If .Range("a2").Value > VBA.Date And UCase(.Range("a1").Value) = > UCase("ON TRACK ") Then >

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

Sub test() With Sheets("Sheet1") If .Range("a2").Value > VBA.Date And UCase(.Range("a1").Value) = UCase("ON TRACK ") Then .Range("a1").Value = "DELAYED" End If End With End Sub On Sun, Mar 30, 2014 at 8:32 PM, Renata Torquato wrote: > I have the following s

$$Excel-Macros$$ Macro for IF & AND condition

I have the following situation: I would like the range (A1) to change to the status DELAYED if this range shows the status ON TRACK and if the deadline date on range A2 has passed the current date (Formula TODAY in another sheet). If the condition is false I would like range A1 to keep its stat

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

Sub test() Dim filenm As String, folderpath As String folderpath = "C:\Documents and Settings\Ashish Koul\Desktop\sample files\" filenm = Dir(folderpath) While (filenm <> "") If InStr(filenm, ".doc") > 0 Then Call copytables(folderpath & filenm) End If filenm = Dir

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

Ashish, The code works great!!! How could it be modified to create a new Excel document for each Word table discovered? Kindly advise. Thank you, Michael On Wednesday, October 2, 2013 1:09:44 AM UTC-4, ashish wrote: > > try this > > Sub import_word_table_to_excel() > Application.DisplayAlert

Re: $$Excel-Macros$$ Macro help needed

Hello Rafael, check the below sub and call the sub @ 'Need help here to do something with the data collected from Sql Server ' * Private Sub WriteDate(rs As Recordset) On Error GoTo ErrorMessage

$$Excel-Macros$$ Macro to create hyperlinks to the master-sheet items to link the Details-Sheet items in a workbook

Hi there, I'm new with excel macros and have to build a macro to hyperlink the items in the Master-Activity sheet with the items in the Details-Activity sheet in the same workbook. Please check out the attached excel file with the sample data and detailed comments. This file has two sheets 1

$$Excel-Macros$$ Macro to automatically convert prt scr image-based text to real text in cell

I need help programming my Excel VBA Macro to do OCR (text recognition) from a prt scr screen capture image and input the text into cells. Currently my Excel file has a push-button, and upon clicking on it the macro pastes into Excel the current clipboard image I have created by pressing prt

Re: $$Excel-Macros$$ Macro to insert an empty row whenever there is a change in value from the cell above

Is there a way to set it to a constant range? I would like the button to be on Sheet1 but inserting the row on Sheet2 (b5:b500) when ever the data changes from row to row, but I just can't figure how to manipulate the code, to do that. This works great on "Sheet1" Column A but I can't get it

RE: $$Excel-Macros$$ Macro to insert an empty row whenever there is a change in value from the cell above

Pfa.. now it will ask u to select range first…… From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aaron Hoffman Sent: Wednesday, March 12, 2014 1:14 PM To: excel-macros@googlegroups.com Cc: Soum Subject: Re: $$Excel-Macros$$ Macro to insert an empty row

Re: $$Excel-Macros$$ Macro to insert an empty row whenever there is a change in value from the cell above

51:24 AM UTC-6, ravinder negi wrote: > > Pfa, if help > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Aaron Hoffman > *Sent:* Wednesday, March 12, 2014 11:54 AM > *To:* excel-...@googlegroups.com > *Subject:* $$Excel

Re: $$Excel-Macros$$ Macro to insert an empty row whenever there is a change in value from the cell above

12, 2014 11:54 AM > *To:* excel-...@googlegroups.com > *Subject:* $$Excel-Macros$$ Macro to insert an empty row whenever there > is a change in value from the cell above > > > > Hi I am new to using macros in Excel, but I was curious if someone could > give me some advi

RE: $$Excel-Macros$$ Macro to insert an empty row whenever there is a change in value from the cell above

Pfa, if help From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aaron Hoffman Sent: Wednesday, March 12, 2014 11:54 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Macro to insert an empty row whenever there is a change in value from the

$$Excel-Macros$$ Macro to insert an empty row whenever there is a change in value from the cell above

Hi I am new to using macros in Excel, but I was curious if someone could give me some advice. I am looking for a macro that will insert a blank row whenever 2 values in the same column don't match. For example in range b5:b500 I have several different dates, and two make the spreadsheet look

Re: $$Excel-Macros$$ Macro Single code require for if condtion

elect > > *Paul* > - > > > > > > > > *"Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you

Re: $$Excel-Macros$$ Macro Single code require for if condtion

fset(0, 12).Value = "" End Select Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley --

$$Excel-Macros$$ Macro Single code require for if condtion

Dear All, Good Afternoon, I have made below code ... I have one doubt in below code. for example Hisar. I have mentioned that if cell contain below HSR-CRD(HR) HSR-HRD(HR) HSR-JMS(HR) HSR-VDJS(HR) HSR-JINDAL HOUSE Then output must be "Hisar" but I have done it with different if condition .

Re: [XL-VBA Clinic] RE: $$Excel-Macros$$ Macro Required

2" in sheet2 >> >> >> >> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] >> On Behalf Of Prafull Jadhav >> Sent: Wednesday, February 26, 2014 3:08 PM >> To: excel-macros@googlegroups.com; excelvbacli...@googlegroups.com >> Su

Re: [XL-VBA Clinic] RE: $$Excel-Macros$$ Macro Required

oglegroups.com; excelvbacli...@googlegroups.com > *Subject:* $$Excel-Macros$$ Macro Required > > > > Dear All, > > Good After Noon, > > I require one macro for attached excel sheet. > > Appreciate cooperation expected from you. > > > > > > Regards,

RE: $$Excel-Macros$$ Macro Required

ups.com; excelvbacli...@googlegroups.com Subject: $$Excel-Macros$$ Macro Required Dear All, Good After Noon, I require one macro for attached excel sheet. Appreciate cooperation expected from you. Regards, Prafull Jadhav 9920553518 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wa

$$Excel-Macros$$ Macro Required

Dear All, Good After Noon, I require one macro for attached excel sheet. Appreciate cooperation expected from you. Regards, Prafull Jadhav 9920553518 -- 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$$ Macro to Download csv file from a dynamic date based url to a specified file location

Ashish, Thanks a lot for the help. This does 90% of what I am looking for. This is awesome and thanks yet again.. However, I require a little more help from your end please, if possible. How do I get some form function (like a button) to trigger popping up pop up box which will ask for a date ra

Re: $$Excel-Macros$$ Macro to Download csv file from a dynamic date based url to a specified file location

http://www.myengineeringworld.net/2013/11/excel-vba-download-internet-files.html http://www.lazerwire.com/2011/11/excel-vba-download-files-from-internet.html http://www.cpearson.com/excel/downloadfile.aspx Declare Function URLDownloadToFile Lib "urlmon" Alias _ "URLDownloadToFileA" (ByVal pC

$$Excel-Macros$$ Macro to Download csv file from a dynamic date based url to a specified file location

Hi, I have a requirement to download a lot of historical data files from the archieve of an website. The url goes something like this: *http://nseindia.com/content/nsccl/fa...i_21022014.csv* This downloads file for 21022014 ie

$$Excel-Macros$$ Macro to to move lines in Pivot table

Dears, I have a pivot table with customer data. Each customer may have several sites. I want to send a webform, but there are constraints to link the data to fields in the form. The “Initial Data” represents the pivot and I want to transform it to what is built in sheet “Transformed Data”.

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

You will not find customised code as per your requirement anywhere. You have to make changes on your own. The above link will tell you how to zip one file and then combine it with mail macro to send that file Regards Ashsh On Thu, Feb 6, 2014 at 5:39 PM, Atul Kesaria wrote: > Hi Ashish, > > W

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

Hi Ashish, What I am looking at zipping respective PDF file as a seperate zip file and not all pdf files in one zip. Sorry but i could not see that in that link. Regards Atul On Thu, Feb 6, 2014 at 12:56 PM, ashish koul wrote: > check this > http://www.rondebruin.nl/win/s7/win001.htm > http:/

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

check this http://www.rondebruin.nl/win/s7/win001.htm http://www.rondebruin.nl/win/section7.htm On Tue, Feb 4, 2014 at 8:31 PM, Atul Kesaria wrote: > Hi Ashish, > > One more help to earlier macro. Is there a way we can put password to the > PDF file or make a zip file of respective pdf file wit

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

Hi Ashish, One more help to earlier macro. Is there a way we can put password to the PDF file or make a zip file of respective pdf file with a password and then email. Password can be predefined to either date of birth or anything else which would be incorporated in the excel file. Regards Atul

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

Thanks Ashishreally helpfull... On Mon, Feb 3, 2014 at 10:50 AM, ashish koul wrote: > try this > > Set Mailrng = Sheets("Sheet1").Range("c2:c" & > Sheets("Sheet1").Range("c1").End(xlDown).Row) > > > On Mon, Feb 3, 2014 at 12:28 AM, Atul Kesaria wrote: > >> Hi Ashish, >> >> You are rockstar.

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

try this Set Mailrng = Sheets("Sheet1").Range("c2:c" & Sheets("Sheet1").Range("c1").End(xlDown).Row) On Mon, Feb 3, 2014 at 12:28 AM, Atul Kesaria wrote: > Hi Ashish, > > You are rockstar. Just one last help. Can the range be set a dynamic > rather than staticas the range will vary from tim

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

Hi Ashish, You are rockstar. Just one last help. Can the range be set a dynamic rather than staticas the range will vary from time to time. Regards Atul On Sun, Feb 2, 2014 at 9:50 PM, ashish koul wrote: > Sub test() > > Dim mailrng As Range > Dim cl As Range > Dim fl_path As String > > >

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

Sub test() Dim mailrng As Range Dim cl As Range Dim fl_path As String Set mailrng = Sheets("Sheet1").Range("c2:c5") For Each cl In mailrng Call sendmail(cl.Value, cl.Offset(0, -1).Value, cl.Offset(0, 1)) Next End Sub Sub sendmail(mailid As String, nm As String, flname As String) Dim OutAp

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

Hi Team, Any luck of my earlier mail. Regards Atul On Sat, Feb 1, 2014 at 10:34 PM, Atul Kesaria wrote: > Hi > PFA fileplease note that the attachment which need to go with each > mail would be a PDF file. > > > On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria wrote: > >> PFA >> >> >> On Sat,

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

Hi PFA fileplease note that the attachment which need to go with each mail would be a PDF file. On Sat, Feb 1, 2014 at 10:33 PM, Atul Kesaria wrote: > PFA > > > On Sat, Feb 1, 2014 at 7:45 PM, ashish koul wrote: > >> please share a sample file >> >> >> On Sat, Feb 1, 2014 at 5:19 PM, Atul K

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

PFA On Sat, Feb 1, 2014 at 7:45 PM, ashish koul wrote: > please share a sample file > > > On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria wrote: > >> Hi Team, >> >> I need a help in getting a macro which will help sending email with >> attachment to list of person in the excel sheet which will hav

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

please share a sample file On Sat, Feb 1, 2014 at 5:19 PM, Atul Kesaria wrote: > Hi Team, > > I need a help in getting a macro which will help sending email with > attachment to list of person in the excel sheet which will have there Name, > email ID,Unique number. Please note that every person

$$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

Hi Team, I need a help in getting a macro which will help sending email with attachment to list of person in the excel sheet which will have there Name, email ID,Unique number. Please note that every person should receive a particular file based on their unique number. File are prestored in a part

Re: $$Excel-Macros$$ Macro to sort in different workbook

can u share a sample file on which column you want to apply sorting and all On Wed, Jan 15, 2014 at 10:52 PM, wrote: > I pull data for individual customers from a source system into an Excel > workbook. I have a separate Excel workbook template that contains macros, > which allow me to reformat

Re: $$Excel-Macros$$ Macro question

can you please share a sample file On Wed, Jan 22, 2014 at 1:49 AM, Bé Trần Văn wrote: > You upload files. > > > > 2014/1/21 Dennis Dieterle > >> First of all, thanks for your time. I have a scheduling project with a 4 >> page spreadsheet (quarterly) of names and avail timescan I create a >

Re: $$Excel-Macros$$ Macro question

You upload files. 2014/1/21 Dennis Dieterle > First of all, thanks for your time. I have a scheduling project with a 4 > page spreadsheet (quarterly) of names and avail timescan I create a > Macro to schedule 14 weeks (different ID's) IF their name=Y then PRINT name > on specific location

$$Excel-Macros$$ Macro question

First of all, thanks for your time. I have a scheduling project with a 4 page spreadsheet (quarterly) of names and avail timescan I create a Macro to schedule 14 weeks (different ID's) IF their name=Y then PRINT name on specific location on FORM? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i

Re: $$Excel-Macros$$ macro code

Hi Boreh, Assuming I = 1, That code is assigning available value in cell B6 to a variable name "AccName" and then on the next cell i.e., Cell C6, it is populating the value of G8 picked up from sheet whose name is there in Cell B6. Cells(5 + I, 2) is B6 Cells(5 + I, 3) is C6 Cells(8, 7) is G8 of

$$Excel-Macros$$ macro code

Hi. I have macro code below. In layman's terms, can someone tell me what exactly it means. Am trying to learn macro 'Enter Op. Bce AccName = Cells(5 + I, 2) Cells(5 + I, 3) = Sheets(AccName).Cells(8, 7) Regards, Boreh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Macro to sort in different workbook

I pull data for individual customers from a source system into an Excel workbook. I have a separate Excel workbook template that contains macros, which allow me to reformat the data in the source workbook. I am trying to "add" another macro that will do additional formatting, but when trying t

Re: $$Excel-Macros$$ Macro to replace cell reference or addresses with their individual calculated values

Ashish ji, macro given by you only paste special in column D. But my requirement is according to given examples above Option 1 on running macro the result should be or option 2 Units Rate Amount 1 3 =1*B2 2 4 =2*B3 3 5 =3*B4 4 6 =4*B5 5 7 =5*B6 6 8 =6*B7 7 9 =7*B8 or option 3 My

Re: $$Excel-Macros$$ Macro Code??

Thanks Ravi its working fine! On Fri, Jan 10, 2014 at 3:29 PM, Ravinder wrote: > PFA > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat > *Sent:* Thursday, January 09, 2014 10:55 AM > *To:* excel-macros >

Re: $$Excel-Macros$$ Macro to replace cell reference or addresses with their individual calculated values

try this Sub test() Range("d2:d8").Value = Range("d2:d8").Value End Sub On Sat, Jan 11, 2014 at 1:38 PM, Mukesh Kumar wrote: > Hello Experts > > Please provide me solution for the query given in attached file. > > Thanks & Regards, > Mukesh Kumar > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT))

$$Excel-Macros$$ Macro to replace cell reference or addresses with their individual calculated values

Hello Experts Please provide me solution for the query given in attached file. Thanks & Regards, Mukesh Kumar -- 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 F

RE: $$Excel-Macros$$ Macro Code??

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deepak Rawat Sent: Thursday, January 09, 2014 10:55 AM To: excel-macros Subject: $$Excel-Macros$$ Macro Code?? Dear All, I need macro to update multiple sheets from one sheet Ref data is

$$Excel-Macros$$ Macro Code??

Dear All, I need macro to update multiple sheets from one sheet Ref data is attached Kindly provide the best code, as if macro run once it couldn't be undo. Regards, Deepak Rawat -- 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 Fa

Re: $$Excel-Macros$$ Macro to change existing formatting of numbers based on Criteria

Hi Milin, Hope its fulfill your requirement Thanks Team XLS On 1/5/14, Milin Sulakhi wrote: > Dear All, > > I cannot write macros hence need your help on it . This Macro will achieve > what I have mentioned below. > > 1. There is a range which I will select in excel. > 2. Run Macro > 3. Number

$$Excel-Macros$$ Macro to change existing formatting of numbers based on Criteria

Dear All, I cannot write macros hence need your help on it . This Macro will achieve what I have mentioned below. 1. There is a range which I will select in excel. 2. Run Macro 3. Number format will change as below in selected cells based on Criteria. These numbers are random and will end wit

Re: $$Excel-Macros$$ macro to compare value against multiple ranges and enter value based on that

can u share a sample file with some dummy data ? On Wed, Jan 1, 2014 at 4:08 AM, Sean Murphy wrote: > Hello, I'm just starting to learn VB and have a relatively easy thing I'm > trying to do (I believe) > > I want the macro to simply look at a value in a cell (lets say F3), see if > it is wi

$$Excel-Macros$$ macro to compare value against multiple ranges and enter value based on that

Hello, I'm just starting to learn VB and have a relatively easy thing I'm trying to do (I believe) I want the macro to simply look at a value in a cell (lets say F3), see if it is within a specific range range, and dependent upon which range it falls into, insert a different value for me in an

Re: $$Excel-Macros$$ Macro for Search Range of Value in each sheets

Thanks Ashish, fantastic this works well well as per my requirements. Great Appreciate all your support. On Tue, Dec 24, 2013 at 9:21 PM, ashish koul wrote: > try this > > Sub test() > Dim i As Long, j As Long, k As Long > Dim wk As Worksheet > > > For i = 1 To ThisWorkbook.Sheets.Count >

Re: $$Excel-Macros$$ Macro for Search Range of Value in each sheets

Thanks Murali, this works out well, but if we have dynamic sheets, then need to add vlookup formula every time. Any how thanks for spending time and providing solution, really appreciate that :) On Tue, Dec 24, 2013 at 3:56 PM, Murali Nagarajan wrote: > Dear Puttu, > > As desired you i enclosed

Re: $$Excel-Macros$$ Macro for Search Range of Value in each sheets

try this Sub test() Dim i As Long, j As Long, k As Long Dim wk As Worksheet For i = 1 To ThisWorkbook.Sheets.Count For j = 2 To Sheets(i).Range("a65356").End(xlUp).Row k = 1 For Each wk In ThisWorkbook.Sheets If wk.Name <> Sheets(i).Name Then If Ap

Re: $$Excel-Macros$$ Macro for Search Range of Value in each sheets

please help On Tue, Dec 24, 2013 at 11:58 AM, Puttu * wrote: > Experts please help on my query > > > On Tue, Dec 24, 2013 at 8:35 AM, Puttu * wrote: > >> Hi Experts, >> >> Need your help. I have workbook which will have n number of sheets. What >> I need is in each sheet column A we have liste

Re: $$Excel-Macros$$ Macro for Search Range of Value in each sheets

Experts please help on my query On Tue, Dec 24, 2013 at 8:35 AM, Puttu * wrote: > Hi Experts, > > Need your help. I have workbook which will have n number of sheets. What I > need is in each sheet column A we have listed some products, it need to > search cell value (Product) in each sheets and

$$Excel-Macros$$ Macro for Search Range of Value in each sheets

Hi Experts, Need your help. I have workbook which will have n number of sheets. What I need is in each sheet column A we have listed some products, it need to search cell value (Product) in each sheets and if the value found just need to enter the sheet name in next column, if the cell value (Prod

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

I don't see anything else except your comment "sure". Am I missing something ? On Wednesday, November 13, 2013 3:21:51 AM UTC-5, Enrique Martin wrote: > Sure > > > On Wed, Nov 13, 2013 at 11:06 AM, Bill Q > > wrote: > >> >> On Thursday, December 13, 2012 8:48:25 PM UTC-5, Enrique Martin w

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

Sure On Wed, Nov 13, 2013 at 11:06 AM, Bill Q wrote: > > On Thursday, December 13, 2012 8:48:25 PM UTC-5, Enrique Martin wrote: > >> My Pleasure.. You have given me new title. >> >> >> On Fri, Dec 14, 2012 at 12:57 AM, Bill Q wrote: >> >>> Just what the doctor ordered. Thank you very m

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

On Thursday, December 13, 2012 8:48:25 PM UTC-5, Enrique Martin wrote: > > My Pleasure.. You have given me new title. > > > On Fri, Dec 14, 2012 at 12:57 AM, Bill Q > > wrote: > >> Just what the doctor ordered. Thank you very much Dr. Anoop. >> >> Much appreciated. >> >> >> >> On Th

Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook

; *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sagar Kasangottuwar > *Sent:* Monday, October 28, 2013 5:20 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Macro for consolidate worksheets from > vari

RE: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook

Did you put path in range "b2" of first sheet.? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sagar Kasangottuwar Sent: Monday, October 28, 2013 5:20 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for consolidate

Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook

ups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sagar Kasangottuwar > *Sent:* Monday, October 28, 2013 1:06 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Macro for consolidate worksheets from > various workbook to specific workbook

RE: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook

Try this one. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sagar Kasangottuwar Sent: Monday, October 28, 2013 1:06 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific

Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook

Dear Rupesh, I want to copy worksheett from various workbooks to single workbook. Thanks & Regards, Sagar On Mon, Oct 28, 2013 at 1:00 PM, Rupesh Patil wrote: > hi Sagar*.* > > *First** all of i want's tell, I am new on this forum so excel, so may > be this link will help you or you want thr

Re: $$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook

hi Sagar*.* *First** all of i want's tell, I am new on this forum so excel, so may be this link will help you or you want through it, * http://www.wikihow.com/Consolidate-in-Excel* * * * *thanks * On Mon, Oct 28, 2013 at 12:32 PM, Sagar Kasangottuwar < sagarkasangottu...@gmail.com> wrote: > De

$$Excel-Macros$$ Macro for consolidate worksheets from various workbook to specific workbook

Dear Experts, I have 100 worksbooks which contains worksheet (i.e. Profitability) so I want to consolidate all the worksheets in one workbook. This worksheet data is linked from other worksheets so I want that data in as it is in consolidated workbook. Kindly help me in this VBA. Thanks & Regard

Re: $$Excel-Macros$$ Macro for Vlookup

Hi Anil, Thanks for that. But I dont need macro to put only formula. I need the macro to do the comparison of 2 list. Can you please help me on that ? Thanks & Regards, Ganesh N On Fri, Oct 25, 2013 at 12:48 PM, Anil Gawli wrote: > Dear Ganesh, > > Pl see the attached sheet. > > > Thanks & R

Re: $$Excel-Macros$$ Macro for Vlookup

Dear Ganesh, Pl see the attached sheet. Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Fri, Oct 25, 2013 at 12:05 PM, Ganesh N wrote: > Hi Team, > > I am learning macros. I have run macro to lookup 2 Employee ID list. But > that is limited if the

$$Excel-Macros$$ Macro for Vlookup

Hi Team, I am learning macros. I have run macro to lookup 2 Employee ID list. But that is limited if the list extended the macro not running for the extended ID's. Also I want to run that macro if the list in any cells. Please any one help me on that. Also please tell me where I need to modify in

Re: $$Excel-Macros$$ Macro code requirement

gt; Sheets(shname).Range("a1").ColumnWidth = 15.4 > > ActiveWindow.DisplayGridlines = False > > Sheets(shname).Range("a7").Validation.Delete > > Sheets(shname).Range("a7") = datash.Cells(i, 1)**** > > > > Next > &

Re: $$Excel-Macros$$ Macro code requirement

kesh Kumar > *Sent:* Wednesday, October 09, 2013 4:44 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Macro code requirement > > ** ** > > Dear Ravinder Ji, > > I have checked the file, but it is making 50 sheets only. Secondly when I > tri

$$Excel-Macros$$ Macro code requirement

Dear Sir, I have an excel file in which there are 300 names are there & they are given different targets. Now I have to take print outs of these 300 names. I have prepared drop down list of 300 names in cell A7 in attached sample file. My requirement is that I want 300 sheets according to dropdow

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

Dear Ashish, Any further help in this matter please. Regards Nasir Khan On Fri, Oct 4, 2013 at 12:38 AM, Nasir Khan wrote: > Yes I did. > But as mentioned in my reply I need the code to > 1) run on all the files in the given Path = Your code run a single folder > at a time...there are several fo

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

Yes I did. But as mentioned in my reply I need the code to 1) run on all the files in the given Path = Your code run a single folder at a time...there are several folder in the given path. 2) Each table should come on a separate sheet - Your code bring in the table one below other 3) The sheet nam

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

have you tried the code which i shared On Thu, Oct 3, 2013 at 1:34 PM, Nasir Khan wrote: > Dear Ashish, > Thanks for the code. > My requirement is to import all the word tables from all the sub-folder in > the given path. > I got the following code from the net which obviously is not working. >

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

Dear Ashish, Thanks for the code. My requirement is to import all the word tables from all the sub-folder in the given path. I got the following code from the net which obviously is not working. Sub DoItNow() Dim file Dim path As String ' the path to the folder ' make SURE you include the terminat

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

try this Sub import_word_table_to_excel() Application.DisplayAlerts = False Application.ScreenUpdating = False Dim fldpath Dim fld, fil As Object Dim appWord As Word.Application Dim docWord As Word.Document Dim tableWord As Word.Table Dim sdoc As String ' use to choose the folder having word doc

$$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

Hello All, I have got lot of MS Word files in a folder eg. C:\Test\ I wish to copy and paste the Tables from all the word documents in the above mentioned folder to excel. I found Macro1 (see below) which copy and paste the Table in Excel. My requirement is to get the tables from all the docume

$$Excel-Macros$$ Macro needed in a file with lookup formulas that will freeze formulas if value is found

Hello I am stuck with an assignment that I have spent a lot of time trying to come up with a conventional solution and I am at a point where I need advise from the esteemed sages on this forum. Output File name: "NAOPIP Review" with multiple line items (~2k). Instructions: The tab has

Re: $$Excel-Macros$$ macro for required data please find the attachment once

Hi अनिल नारायण गवली, can you please tell me how to use your file thanks *(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks & Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪* * * *P Let us do our best to save nature

$$Excel-Macros$$ Macro File Saving Restriction

Dear All, As you all know if a .xlsm or .xlsb file is saved under .xlsx or non-macro enabled file extension in those files macros do not work or visible. So i want to make a restriction in macro enabled files .xlsm or .xlsb that they cannot be saved under non-macro enabled file extension. Is it p

Re: $$Excel-Macros$$ macro for required data please find the attachment once

Here i'am using Multidimension array to get faster result This will little longer in code, but will much faster then Direct Manipulation Data using For Each ... in Range... Next (Loop) And then... Here we go... Sub Convert() Dim Data, Hasil, LCount As Long, LRow As Long, iCol As Integer

<    1   2   3   4   5   6   7   8   9   10   >