1 Attachment(s)
Copy Columns and Formula to a Database sheet
hi all :wave:
i need use 1 of my excel file(book3) to supply different formula to different excel file example (book4) in sheet2 and copy some of the column in book4 (sheet 1 into sheet 2).any 1 know how am i able to do that without typing any coding in book4 cause making it for an end user all coding is done in book3 thx.sorry for my poor explaination if is confusing but any one can help thx my excel file in the zip
Re: Copy Columns and Formula to a Database sheet
Record a Macro in Excel and then once recorded click Tools --> Macro --> Visual Basic Editor and view the code required to do what you want. HTH :D