Macro to copy

To help the community support you more effectively, it would be useful if you could clarify a few things:

What exactly is the source cell or range you want to copy from?

Where do you want the value pasted (a specific sheet/cell, or dynamically chosen)?

Should this copy happen automatically (e.g., when data changes), or only when you run a macro manually?

Provide detailed information about the file (if known), including which Excel version (Excel 2016, 365 Home, etc.) was used to create the file?

Whether the file extension has ever been changed (.xls, .xlsx, .xlsm, etc.)?

Which operating system you are using to open the file, e.g., Windows 10 (21H1)?

 …and what medium is the file saved on (OneDrive, Sharepoint, hard disk, etc.)?

If you can share a short description of your data layout (or a simplified example, rather than sending full files), it will be much easier for others to suggest a working macro.

Many people here prefer not to receive files directly by email for safety reasons, but if you can describe or paste a sample setup, the community can usually provide a solution quite quickly.

That way someone can give you code tailored to your exact need.

Thank you for your understanding and patience

Hope I was able to help you with this information.