Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Yiannis
 
Posts: n/a
Default Automatic updating worksheet data between different workbooks

Dear Excel users,

The problem that I have and dont know how to deal with it is the following.

I have a master workbook with all the expenses of my company. This master
workbook has many different worksheets, one for each expense category (one
worksheet for print adv, one worksheet for tv adv, one worksheet for research
costs etc).

I have copied-paste each one of these different worksheets into blank excel
workbooks (so the new workbooks created are as many as the workshhets on the
master workbook) and assigned some people in my company to fill in these
workbooks.

What I want to do is to make the master workbook read the values entered in
the separate workbooks every time I open it and make the updates. If it was
for a few cells only, I could do it manually (click the mouse to a cell in
the master workbook, press = and then click the mouse to the relative cell in
the other workbook and press enter). But here we are talking of big big big
workbooks, thats why I am looking for a way to do it more easilly.

Any ideas? I have to tell you that I dont know VBA, so if you have any ideas
that have to do with macros, please tell me what to do in order to record the
macro.

Thanx a lot
Yiannis
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic cell increment with data from sheet 1 to sheet 2 Big G Excel Worksheet Functions 2 December 20th 04 06:59 PM
use data on master worksheet for sorting Ken New Users to Excel 1 December 7th 04 04:30 AM
URGENT Please... new worksheet with copied formats but no data. DarrellK Excel Worksheet Functions 2 December 1st 04 08:11 PM
Reference Data in Moved Worksheet tommcbrny Setting up and Configuration of Excel 1 December 1st 04 07:49 PM
Automatically pull data into another worksheet within the same fil TJess Excel Worksheet Functions 1 November 15th 04 09:00 PM


All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"