I am a newbie and running into problems everyday and need your help. I have a autosheet. I wanted an upload button which when clicked and excel files selected through it and when clicked Copy button will copy the below values from the excel sheet selected to AutoSheet
column C2 in file selected represents cell c2,e2,g2,i2,k2,m2,o2
column D2 in file selected represents cell c3,e3,g3,i3,k3,m3,o3
column E2 in file selected represents cell d3,f3,f3,j3,l3,n3,p3
Suppose if "BIM Report May 24 - May 30.xlsx" is selected in AutoSheet through upload button and clicked Copy , then in AutoSheet in 2015 worksheet C85,D85,E85 for May 24 will be filled from C2,C3,D3 from BIM Report May 24 - May 30.xlsx sheet and similarly C86,D86,E86 for May 25 sholuld be filled till C91,D91,E91 for May 30 respectively
AutoSheet and 2 sheets that have to be browsed is uploaded below.
ABC BIM Report May 24 - May 30.xlsxABC BIM Report May 31 - June 6.xlsxAutoSheet.xlsm
Bookmarks