• 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.

Keep data while deleting sheets that include formulas?

T

trident50

New Member
Hello,
Now that Haseeb - thanks Haseeb! - has helped me out on here, I'm able to use the formula he gave which, essentially, moves specific data from one sheet to the another sheet.

But when I delete the sheet that originally held the data, the data disappears on the other sheet.

Thanks!
Rob

ps...If anyone has any suggestions here is what I'm originally trying to do…..

I have one file that is 1.2gb, 2 columns. I have file that is 8mb, 24 columns.

I now have the formula to move data from column B, in the 1.2gb file, into column U,
in the 8mb column - only where Columns A match.

But this 1.2gb file is crashes Excel…even Power Pivot gives an error that the data in Column B - which can be extensive text - is too large.
 
Having no idea of what was posted previously . . . what comes to mind for me is using the advanced filter to copy the data you wish to another sheet based on criteria.

Your present solution seems to be based on writing formulas on the second sheet that reference the fist, such that when you delete the first sheet the results on the second have nothing to reference.
 
After you use a formula to bring the information over, you'd want to change it to a static value, by copying the cells and then doing a Paste Special - Values. Note that this removes the formula, but does obtain your goal.
 
Hi Luke, I tried that….copy everything over with no values. But when I run the formula again, using the next sheet, it removes the values already in column U.

Not sure Excel can actually handle this…ideally I'd like to be able to do this one time with the the large, 1.2gb, sheet and the smaller one….and then just have the smaller one to deal with.
 
But when I run the formula again, using the next sheet, it removes the values already in column U.
Click to expand...
To clarify, are you using a formula, or a macro? The former would only over-write something if you yourself were copying the formula over data. If it's a macro, I'd have to know what the macro is doing in order to advise better.
 
You must log in or register to reply here.
Back
Top