Hi All,
Not being very adept at VBA i'd like some assistance from those of you more skilled in the art.
In my workbook i have multiple worksheets. Each of my "forms" will have a varying amount of data that i fill in for my inspection work.
When i'm done filling out any of my forms I'd like have it so that each time i click on a button on the form the data get's transferred / transposed over into single row's on a new worksheet. I wish to retain the data in a cumulative sheet as i over-write each form when i'm done printing it.
1/ The name of the source worksheet will vary, but in this case it's my "Ex tD" form.
2/ The name of the destination worksheet will be fixed in this case it's called "EPEE REGISTER".
3/ I need the data to be transferred over to the next single empty row of the "EEPE REGISTER" sheet.
4/ The source worksheet's form data will contain blank cells which i need to retain.
5/ The data on the source worksheet must be read in the order of the rows from top left to bottom right (ie A1,A2,A3 THEN B1,B2,B3 etc).
6/ I'd be happy to only get the above sorted out, but also if it's humanly possible when the button is clicked to initiate the data transfer i'd also like it to initiate a "print preview" as i print the forms out when i'm done filling them out for the clients. The reason i'd like to do this is it will remind me to click on the button so i don't forget to transfer over the data!
7/ I'm using Excel 2010, but any functionality would ideally be backwards compatible with 2003 and 2007.
P.S - While i'm here, I'm using dynamic range data in all my drop down lists. Is it possible to write a text value to cell's that have drop down lists based on the text string result of another cell? i.e IF $G$15="Detailed" THEN J17,J20="N/A"
The file is just a tiny bit over the upload limit, so if you need my original (INSPECTION SHEETS v1.07.xlsm) i'm hosting it on my ftp server here -
ftp://pocko.dyndns.org Username: DOWNLOAD , Password: DOWNLOAD , Port: 21
Modified files can also be dropped of there by using different a login of Username: UPLOAD , Password: UPLOAD
Any help would be greatly appreciated, Thanks - Chris.
Not being very adept at VBA i'd like some assistance from those of you more skilled in the art.
In my workbook i have multiple worksheets. Each of my "forms" will have a varying amount of data that i fill in for my inspection work.
When i'm done filling out any of my forms I'd like have it so that each time i click on a button on the form the data get's transferred / transposed over into single row's on a new worksheet. I wish to retain the data in a cumulative sheet as i over-write each form when i'm done printing it.
1/ The name of the source worksheet will vary, but in this case it's my "Ex tD" form.
2/ The name of the destination worksheet will be fixed in this case it's called "EPEE REGISTER".
3/ I need the data to be transferred over to the next single empty row of the "EEPE REGISTER" sheet.
4/ The source worksheet's form data will contain blank cells which i need to retain.
5/ The data on the source worksheet must be read in the order of the rows from top left to bottom right (ie A1,A2,A3 THEN B1,B2,B3 etc).
6/ I'd be happy to only get the above sorted out, but also if it's humanly possible when the button is clicked to initiate the data transfer i'd also like it to initiate a "print preview" as i print the forms out when i'm done filling them out for the clients. The reason i'd like to do this is it will remind me to click on the button so i don't forget to transfer over the data!
7/ I'm using Excel 2010, but any functionality would ideally be backwards compatible with 2003 and 2007.
P.S - While i'm here, I'm using dynamic range data in all my drop down lists. Is it possible to write a text value to cell's that have drop down lists based on the text string result of another cell? i.e IF $G$15="Detailed" THEN J17,J20="N/A"
The file is just a tiny bit over the upload limit, so if you need my original (INSPECTION SHEETS v1.07.xlsm) i'm hosting it on my ftp server here -
ftp://pocko.dyndns.org Username: DOWNLOAD , Password: DOWNLOAD , Port: 21
Modified files can also be dropped of there by using different a login of Username: UPLOAD , Password: UPLOAD
Any help would be greatly appreciated, Thanks - Chris.
