asked on

Part 3 - Copy only hardcoded values to the correct row and column of a another spreadsheet

I found one column not working as expected.

This only applies to Rows 4 thru 34:

Col J: Formulas, only copy over if hardcoded (This is the one not working as expected)
Col K: Values
Col L: Not Used
Col K: Not Used
Col N thru Y: Values

Jacques Geday

Look at your post !!!!

quote
Col J: Formulas, only copy over if hardcoded (This is the one not working as expected)
Col K: Values
Col L: Not Used
Col K: Not Used
Col N thru Y: Values
Unquote

You have K twice !!!
M is missing !!!
gowflow

Jacques Geday

Presume you meant:

quote
Col J: Formulas, only copy over if hardcoded (This is the one not working as expected)
Col K: Values
Col L: Not Used
Col M: Not Used
Col N thru Y: Values
Unquote

Positively, then pls see attached.
gowflow
UpdatePrevMonthForcastV06.xlsm

ScottBarnes

ASKER

You are correct, I meant:

Col J: Formulas, only copy over if hardcoded (This is the one not working as expected)
Col K: Values
Col L: Not Used
Col M: Not Used
Col N thru Y: Values

Column J for rows 4 thru 34 is still not working as expected. Please treat it like the formulas cells in Row's 40+. Only copy it over if it is a hardcoded value. You are copying it over if is a hardcoded value or if the Updated Forecast file has a different value than the original.

Jacques Geday

ok I will look at this (Col J)

but are you sure for Row 34 ??? it does not have a segment. You did not mean 4 to 33 ???
gowflow

ScottBarnes

ASKER

You are correct, just for rows 4 to 33.

ASKER CERTIFIED SOLUTION

Jacques Geday

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ScottBarnes

ASKER

Perfect. Thank you.

Jacques Geday

ok great. Lets move to Part 4
gowflow