Values to be routed from one sheet to other sheets

Dear All,

Attached excel in which I will keep on enter the values daily which will be routed to other sheets based on the date

Please provide me VB Code and do the needful.

Ex: When I entered the date in E3 & values from C5 to C30 & from F5 to F30 & from H to O columns, it should be routed to other sheets based on the formulas that already placed in the report

See attached.

Please Login or Register  to view this content.

Dear John,

Everything is perfect!!!! Just small things to be done. Total Production also to be routed as shown in my excel (marked it in red in GF, FF etc sheets) & data also should be routed to last sheet Test Report . Provided the references in the cells for your reference.

I think Total Production might have confused as there are multiple productions

Please route values of total production, Test Report Sheet also and do the needful.

I have commented out copy of "Total Rejection%" as I am not sure whether it should be calculated in "Test Report".

To remove comment, delete " ' " (single quote) in macro

' ws1.Range("O73").Copy Destination:=ws2.Cells(37, outcol)

And you should avoid using merged cells for data: it causes problems when copying from merged to unmerged cells.

In future please CLEARLY define what you require rather than leaving respondents to guess/interpret your requirements.


See attached.

Please Login or Register  to view this content.

Sure Buddy!!!!!

Sorry for Bothering you!!!!

Even now Total Production is not displaying in sheets PC GF, GF LC, PC SF. Except that everything is perfect and it is as per desired.