PC Review Forums Software General Software Help (Excel): How to add same cell in multiple workbooks?

Reply
 
Thread Tools Rate Thread
Old 10-02-2009, 05:24 PM   #1
felcadz
Junior Member
 
Join Date: Feb 2009
Posts: 1
Trader Rating: (0)
Default Help (Excel): How to add same cell in multiple workbooks?

guys, please help my excel for my estimation.

i want to add value in same cell across multiple workbooks.

example:
vduct 1F.xls sheet1 A1
vduct 2F.xls sheet1 A1

down to

vduct 35F.xls sheet1 A1

there is 35 workbooks in all.
i want to add cell A1 in from vduct1F.xls - sheet1 to vduct 35F.xls - sheet2
im adding it one by one by adding each cell in each workbook. but after the 6th formula input, it says "too long formula".

hope someone will help me..
thanks in advance..
felcadz is offline   Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off