• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copying sheets in workbook to another workbook without changing in formulas

Abdulrahman7

Abdulrahman7

New Member
Hello everyone !

i have workbook (dashboard) which has 8 sheets. Separately in another workbook (Training Report) i have created a sheet called Training list and another sheet called Report which reads data from the list. i want to copy both sheets to my dashboard workbook.

actually i did but the problem the formulas are showing the address of the Training Report workbook.
How can I make it individual, the formulas should read data from copied sheets not from the Training report worksheet


Thank you in advance
 
Hello Abdul,

Try moving the sheets to the dashboard workbook. Alt+E+M is the shortcut key which gives a popup window. In that, Dashboard needs to be selection from "To book" section and click on Create a copy and click OK. It should work. Just check.

Thanks,
Pavan.
 
Hello Pavan,

Thank you for replying i tried what you said but i think i didn't get that then i tried another solution i opened both workbook view side by side then i dragged both sheets to the dashboard and it worked.


Thank you again :)
 
You must log in or register to reply here.
Back
Top