Excel worksheets linkage

[sultanomar1996]

Hi everyone,

Can I link two different Excel sheets using VBA?
one sheet has the data which we get from our client, the other sheet is where we analyze the data.

can I have the VBA automate the process so that whenever I get the monthly sheet from the client directly I can transform it to my Excel file?
need your help, I am kind of new in VBA.

 

[BobBridges]

Your description isn't very specific, omar, but sure, generally speaking you can write a VBA program to read one workbook and do something with that data in another workbook. But you'll have to be very specific about what exactly you want to do; just "process" and "analyze" and "transform" don't really tell us anything (which may be why no one's answered yet; they're waiting for details. Maybe).

 

[Marc L]

Can I link two different Excel sheets using VBA?

Hi, maybe yes, maybe no : as it depends on missing informations, if sheets are smart enough or created by Dumb & Dumber …​

​