Getting Error =sum(#ref ) when trying to copy Ranges of cells to another workbook

**JJFletcher** · 04-01-2016, 12:31 PM

Hello All,

I am getting Error =sum(#ref ) when trying to copy Range of cells to another workbook

Below are the workbooks The code used in 2016MonthlyGoalsMasterAveragesV1.0 is

Please Login or Register  to view this content.

Hopefully there is a solution!

Best Regards,

John

**shg** · 04-01-2016, 12:40 PM

The formulas in col N refer to values in col F. If you copy those formulas to col F, they reference cells off the left edge of the worksheet.

**JJFletcher** · 04-01-2016, 12:46 PM

Thanks SHG,

How then should I write the code so only the number transfers to the workbook ignoring the Formula portion of the Code that is associated with that cell?

**shg** · 04-01-2016, 01:03 PM

Please Login or Register  to view this content.

**JJFletcher** · 04-01-2016, 01:15 PM

SHG,

Works perfectly - Thanks so much...

I am having to create a new workbook for each month and manipulating the code in the MasterAverages workbook to transfer data for that month to the Master... Is there a way to work within the same workbook and just change the month as needed... If not, changing the code from one month to the next isn't the worst thing to happen but looking to make it easier...

John

**shg** · 04-01-2016, 01:24 PM

Other than looking at the first workbook for 30 seconds to understand the problem, I don't know what you're trying to do.

As a completely general comment, my first inclination would be to figure out how to put ALL of the data on a single worksheet, and then use filters, pivot tables, whatever, to extract the data you need for a given report.

**JJFletcher** · 04-01-2016, 01:32 PM

Excellent, I will get right into that...

Thanks Again So Much,

John

**shg** · 04-01-2016, 01:37 PM

You're welcome, John.

Getting Error =sum(#ref ) when trying to copy Ranges of cells to another workbook

LinkBack

Thread Tools

Rate This Thread

Display

Getting Error =sum(#ref ) when trying to copy Ranges of cells to another workbook

Re: Getting Error =sum(#ref ) when trying to copy Ranges of cells to another workbook

Re: Getting Error =sum(#ref ) when trying to copy Ranges of cells to another workbook

Re: Getting Error =sum(#ref ) when trying to copy Ranges of cells to another workbook

Re: Getting Error =sum(#ref ) when trying to copy Ranges of cells to another workbook

Re: Getting Error =sum(#ref ) when trying to copy Ranges of cells to another workbook

Re: Getting Error =sum(#ref ) when trying to copy Ranges of cells to another workbook

Re: Getting Error =sum(#ref ) when trying to copy Ranges of cells to another workbook

Thread Information

Users Browsing this Thread

Similar Threads

Copy Ranges From Second Workbook

[SOLVED] Copy two ranges from one workbook to another

[SOLVED] VBA Copy Ranges from a Worksheet to a Workbook

Dynamic Ranges error after renaming workbook

Copy-Paste cells from from 1 workbook to another: Run-time error '438'

Copy ranges to new CSV workbook

copy two ranges from a workbook to another

Bookmarks

Bookmarks

Posting Permissions