Hello,I am the person that will be helping you today.
How may I help you today?
I will be standing by, looking forward to your response.
Please, help me understand your problem so that I can help.
Thank you for the update.
What is the formula before the copying?
What is the formula after the copying?
Okay. How do you want this to work? The rows need to pull information from different sheets. "How" does Excel know that?
When you paste cell formulas, Excel only understands that you are moving the location of the formula and changes the formula to match the new location, accordingly.
I have run out of ideas.
For this reason, I am opting out of the question and allowing another expert the chance to help.
The next expert will see all that is on this page, so there will be no need to repeat anything.
When another expert picks this up, you will be notified by email.
Thank you for your patience.