$$Excel-Macros$$ Login & password in excel

-- 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 FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

Re: $$Excel-Macros$$ Re: Macro to copy data from a specif range from many closed workbooks in a folder to a master file creat

Sub merge() Dim fld As Object, fil As Object, fso As Object, fldpath With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Choose the folder" .Show End With On Error Resume Next fldpath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems

Re: $$Excel-Macros$$ Macro to copy data from a specif range from many closed workbooks in a folder to a master file creat

Can you please let us know if all files saved in a single folder or in multiple folders? Can you please share some dummy files and master file how the output will look like Thanks Ashish Sent on my BlackBerry® from Vodafone -Original Message- From: Dragomir Zhelev Sender: excel-macro

$$Excel-Macros$$ Macro to copy data from a specif range from many closed workbooks in a folder to a master file creat

Dear Excel and VBA lovers, This forum is great learning new skills and getting the right knowledge. As I am going deeper into the VBA coding I have came accross the following problem which is impossible for me to solve with my current knowledge and skills in VBA: I need to copy a range of cell

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$$ Need help to find the missing emp id on particular date

Thankyou again, Mr Paul, for the detailed explanation. Regards Eugene On Tue, Apr 15, 2014 at 5:10 PM, Paul Schreiner wrote: > I use it for a wide variety of purposes. > > Sometimes I use it like a pseudo-index. > Say I have a large number of records (I routinely have lists of 90,000 > rows) >

Re: $$Excel-Macros$$ inserting missing date in data

Dear Paul, thanks for your response. the line which is giving the error is If Cells(i, "A") < Cells(i + 1, "A") - 1 Then the date format is 01/01/2001 i tried to run the macro as you suggested. it is giving me the same error. i think the date format is a problem then. appreciate your help shah

Re: $$Excel-Macros$$ Copy Identical Headings from various sheet to a Result sheet

Dear Vicky, Thanks for your time and help. As mentioned by you, at present the data format is required from these 4 columns Can it give me an option to say which Columns from all the sheets should be copy/pasted on the Result sheet. Regards On Monday, April 14, 2014 10:53:46 PM UTC+4, Vicky wrot

Re: $$Excel-Macros$$ inserting missing date in data

What line is giving you a mismatch error? What are the values of the two cells being compared?     also, you're setting LR = the last row of data in column "A", but then never use the value (so it's unnecessary).   I ran this macro on a sample file that had 132,000 rows and it worked as I expected

Re: $$Excel-Macros$$ Inserting Copied cells multiple times

Hey Look attachment, this is more of dyanamic in nature for your requirements & will help you sure. Cheers! On Wed, Apr 16, 2014 at 7:10 AM, Puneeth Reddy Ambati wrote: > > Hi, > > I need some help in excel using Macros. I need to insert a row multiple > times. > > For example > > Present : >