I would like to have Excel -VBA code for the following scenario. I have Excel-2007 hence code should be compatible. I do not want vb.net or Visual Basic Development environment solution. I require excel resident Visual Basic Editor solution.
1. There are 2 workbooks WB1 and WB2 in closed form.
2. User to specify full path to two workbooks in two parts a) File directory path and b) File name (Graphic User Interface like forms with or without REFEDIT mode ie GUI)
3. User to specify Sheet names of two workbooks WS1 and WS2 in GUI
2. Data transfer situation could be following in either or mode ie any one of the following for 2 workbooks on user specified sheets to be specified in GUI.
a) User specified Contiguous range such as B15:W300 in WB1 on user specified sheet to be posted at user specified starting location in user specified worksheet in WB2 such as "G15"
b) User Specified Multiple Non Contiguous Ranges such as B15:j75 And N30:R100 in WB1 user specified worksheet to be copy pasted to user specified starting location for contiguous ranges on WB2 maintaing relative row offset for example A2:I62 and J17:N87
c) User specified Rows such as A30 upto last used row or user specified last row to be appended to first empty/blank row in the specified sheet also provision to be made for pasting to new additional sheet.
d) User specified Columns Contiguous or Non contiguous Multiple columns to be copy pasted at user specified starting location or to be appended to lastempty/blank column.
e) user specified copy pasting mode for values only or data with formulas mode in GUI.
I am not providing any code as my level is no match to experts level here and my piece-meal code will not serve any purpose. It may confuse more. Still if required to show my efforts I will post it on demand.
I am attaching a sample file.
Hope I have detailed out my requirements. I require full working program code.