HI all i am working in exel need some hlp

[hatric]

HI i am novice to EXel and now using it, but i hav some probles in using it as database plz help

viz. i am gettiing data from my colugues in exel form weekly basis and merg them in one exel sheet by manualy , can i import and link many exel files data in one master file, plz suggest

thanks
hatric

[bartonc]

HI i am novice to EXel and now using it, but i hav some probles in using it as database plz help

viz. i am gettiing data from my colugues in exel form weekly basis and merg them in one exel sheet by manualy , can i import and link many exel files data in one master file, plz suggest

thanks
hatric

If you don't know any Visual Basic, you can start off by recording your actions using "Record Macro". From there, start learning VB by reading what's in side the macro that you have just recorded. Don't ask me how I know this, because I haven't touched Excel in over 15 years, but it is a starting point.