Surely I can help you out on this, but I would need one information, what would be the sheet name of the workbook.
Thanks, Mukesh On Thu, Mar 5, 2009 at 7:54 AM, Roopesh Kapur <roopesh.ka...@gmail.com>wrote: > > Hi Everyone, > > I need some help from you all, my requirement is that there are 11 people > in > my team and each one uses a different workbook as theri MIS at the end of > the day I have to combine data from each ones MIS into a master MIS. Few > Points. > > 1) All the workbooks are saved in the same location. > 2) The format is a standard > > Can this be automated, such that at the end of the day, I tell the macro > the > path of the folder where the MIS' are saved and then it goes to that > folder, > opens each file, copies data from a particular sheet, copies the data in my > master MIS, closes the MIS and then opens the next one repeats the cycle. > > This way I will save lot of time and will get the MIS of all my team one > below the other. > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > On Behalf Of Peter Jorgensen > Sent: Wednesday, March 04, 2009 10:17 PM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Re: Find next available row > > > If the next available row is the first blank row on the spreadsheet you can > use this: > > iNextRow = Worksheet("MySheetName").Range("A65535").End(xlUp).Row + 1 > > Worksheet("MySheetName").Range("A65535").End(xlUp).Row returns the row > number for the last row in column A with data in it (you can change the > range to use a different column) and then adding 1 will give you the next > available row. You can use this then like so: > > Worksheet("MySheetName").Range("A" & iNextRow).Value = Date > > This will put today's date in the next available row. > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > On Behalf Of iwasinnihon > Sent: Wednesday, March 04, 2009 8:39 AM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Find next available row > > > I am writing a macro and would like to have it find the next available > row on a sheet, enter the date, do a vlookup, and enter a running > sum. I can do everything except find the next available row. How > would I do this? > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
