Hi, I am new to the form but other member questions has helped me alot in the past - Thanks
I have a problem that is a bit difficult for ne to explain but I’ll try
I have a Master workbook that updates from 3 other workbooks. Each workbook has a master sheet and then 30 worksheets. My problem is I want to copy formulas from one worksheet to another worksheet in my master and change the corresponding reference worksheet.
Example:
How do I copy the formula into Sheet3 A1 of the Master Workbook and have the corresponding sheet updated in the formula (should read: '[Workbook1]Sheet3'!A1+'[Workbook 2]Sheet3'!A1+'[Workbook 3]Sheet3'!A1) If I copy the formal from sheet1 the formula stays the same (Workbook1]Sheet1'!A1+'[Workbook 2]Sheet1'!A1+'[Workbook 3]Sheet1'!A1)
Master Workbook
Sheet1 A1= '[Workbook1]Sheet1'!A1+'[Workbook 2]Sheet1'!A1+'[Workbook 3]Sheet1'!A1
Sheet2 A1 should be = '[Workbook1]Sheet2'!A1+'[Workbook 2]Sheet2'!A1+'[Workbook 3]Sheet2'!A1
Sheet3 A1=
Workbook 1
Sheet1
Sheet2
Sheet3
Workbook 2
Sheet1
Sheet2
Sheet3
Workbook 3
Sheet1
Sheet2
Sheet3
Any ideas?
Thanks
Bookmarks