Forum Discussion
Macro to copy
Hello all you "Brilliant Minds" here is a chance to prove your "Excel-ence. I want to copy a value to one cell from the source which is random and as I haven't a clue about this stuff I asked Microsoft CoPilot. Being on the 4th version Where Microsoft excel still will not accept Microsoft CoPilot's creation, I am appealing to the Community. So here is your chance to prove that you are smarter than CoPilot.
Here we go, everything but attach a file. If anyone is interested send me an email so I can send a couple of small files.
Donald
1 Reply
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.
