I have two worksheets on a fie
(#1 Worksheet is entitled Basic)
(#2 Worksheet is entitled Financial Plan)
The Basic worksheet has many columns and some of the data is "Funding Centers", "Purchase Requisitions" & "Purchase Orders"
I run a system called Business Warehouse and it populates these fields of the Basic Worksheet. When data is "Missing" it will show a #N/A in column A of the Basic Worksheet
What I am trying to do is set up an IF Statement on the Financial Plan Worksheet that will read the Basic Worksheet and if there is an #N/A in column A, than it will copy the values from column C, D, E, F & G of the basic Worksheet over to columns B, C, R, S & Q of the Financial Plan Worksheet?
I hope this makes sense??
Thank you!!
Bookmarks