Excel Sheet Data Copy
₹12500-37500 INR
Posted 1 minute ago
•
Ends in 6 days
₹12500-37500 INR
Paid on delivery
I have a source worksheet in an existing Excel workbook and I simply need every row and column, exactly as they stand, duplicated onto a destination worksheet within the same file. This is a one-off transfer for the current set of files—no ongoing automation required—so a quick, clean solution is all I’m after. You are free to accomplish this with a VBA macro, a short Power Query routine, or another straightforward method, as long as the result is a workbook where the second sheet is an exact replica of the first. Please keep cell formats, formulas, and any hidden rows or columns intact. To wrap the job up, just send back the updated workbook (or the macro-enabled file) plus a brief note explaining how you performed the copy so I can repeat it later if needed.
Project ID: 40817674
About the project
6 proposals
Open for bidding
Remote project
Active 6 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
6 freelancers are bidding on average ₹22,292 INR for this job


Hi, the copy itself is simple, but any formula that names your source sheet will keep pointing back at the original after a plain duplicate, and that breaks the exact replica you asked for. I would first list every formula that refers to the source sheet by name, then duplicate the sheet inside the same workbook so cell formats, hidden rows and columns carry over as they are. After that I would repoint those formulas to the new sheet and compare the two sheets cell by cell before sending the file back. You would get the updated workbook with a short note listing the steps, so you can repeat the copy later.


Hi, I understand you need the first worksheet copied into a second sheet in the same workbook with every row, column, format, formula, and hidden item kept unchanged. I will check the source and destination sheets, use a clean Excel or Visual Basic method, and verify that the duplicate matches the original before sending the updated file. I will also include a short note explaining the steps so you can repeat the copy later. Should the duplicated sheet keep the same formulas referencing the original workbook, or should all formulas remain exactly as currently written? Please start the chat and let’s discuss the workbook and destination sheet.
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗