Hi,
I'm doing a Kanban template with excel which works by dragging info from cells to other cells. For other purposes, I've got another worksheet (2) with cells referenced to other cells from the first worksheet that when info is dragged the reference error appears on worksheet 2. The fact that I'm dragging text/numbers to A5 (eg), and the cell B5 on worksheet 2 being referenced to A5 as =Worksheet1!A5, makes the error appear. Any solution to this?
Thank you.
Last edited by iturriko; 11-29-2018 at 05:55 PM.
Try this
Formula:
Please Login or Register to view this content.
Hello and welcome to the forum.
You have a few options. Here are two:
1) Copy/Paste (then delete the original) instead of dragging
2) Use a formula that does not directly refer to the cell, for example, =INDEX(Worksheet1!A:A,5) instead of =Worksheet1!A5
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks