I have a excel workbook consisting of 3 sheets. One sheet name is 'importeddata' in which 10 columns exist starting from b5 to k1000(b5:k5 is the heading of the columns). Another sheet name is 'Main Form' in which 10 columns exist starting from b5:K1000. Now i want to put 'column (c6:c1000) and column (g6:g1000)of the importedata sheet data (except b265:b435 and g265:g435)' into 'column b6:b1000 and D6:d1000 respectively of the main form sheet'. Please don't import 'except range' (i.e b265:b435 and g265:g435) data in the main form
Column E,F,G,H of the Main Form contain some information which needs to be processed automatically through vba code.
Column G6:G1000 of Main Form has the following formula '(E6/F6)*4' Column H has this formula 'D6/G6' Column J has the following Formula = I6*5 All the formulas should work automatically for the rest of the data.
Now write some VBA code under command button/rectangle that will produce my desire results with just a click.
I will be grateful to you. Because i do it manually everyday.
I am looking forward to hearing response from you soon. Thank you very much in advance.