Excel Help (Excel): How to add same cell in multiple workbooks?

F

felcadz

Joined
Feb 10, 2009
Messages
1
Reaction score
0
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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to add numbers in same cell? 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel, assign cells in multiple worksheets from one sheet 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
How to reference a cell from anther workbook without opening it 0
summarizing data from various workbooks 3
Excel Excel macro Help!! 0
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1

Top