URGENT.....Simple problem...made hard??
I am stuck with a simple problem. I have a 'calculator' workbook i created that accesses information via an external database. This returns information to cells when a part no is keyed in. This information summarises along a bottom row (19). I would like the user to simply click a button and have designated cells copy to a sheet called 'summary'
being an external database...will this be a problem?? The row to copy is always 19 on sheet FEDEX. Columns A-E and H-J. They should copy to sheet 'summary', row 19 columns A-G respectively. Also, as this may occurr up to 60 times, i would like the data to insert one after the other row 19,20,21...etc and have the rows expand as they are added (insert new row with each addition to accomodate)
Please say this can be done???? Can someone provide a code???? Is the database info a problem?? All i need copied is the font inside the cells....no formatting???
Please help ASAP!!!
|