I have a work book which has few spreadsheets
1 spreadsheet name FC
SECOND sheet name SV81 , third sheet name SV83 ,fourth sheet name SV85
In the first spread sheet i had a drop down box with options SV81,SV83,SV85.
What i want is if i select SV81 from my drop down box, i want all the rows to be copied from sv81 & paste on the FC (main) sheet,....
Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.