I have a general template I use to input client data that is set up so that rows with empty cells in a certain column (i.e., there is no data for particular variable for a client) are deleted. For example, if there is no data entered in say G27 for a variable listed in A27 then row 27 is deleted. I would like to be able to transfer data automatically from these client data sheets (each client has own workbook) into a master database. At this point there are thousands of client workbooks. I am not certain how to create code that would transfer data to a master database while accounting for the fact that not all individual client workbooks will have all of the same same variables and data (e.g., if a client didn't have data in cell G27 for a variable in listed in cell A27 the row would be deleted). Any help would be greatly appreciated. I am stumped.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
