Could you share the workbooks your team members are using? _________________________________________________________________________________________________ "There are known knowns. These are things we know that we know. There are known unknowns. That is to say, there are things that we know we don't know. But there are also unknown unknowns. There are things we don't know we don't know."
________________________________ From: Roopesh Kapur <roopesh.ka...@gmail.com> To: excel-macros@googlegroups.com Sent: Thursday, 5 March, 2009 7:54:45 AM Subject: $$Excel-Macros$$ Automating the MIS 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? Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/ --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
