Excel cells - forbid usage

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:29 PM GMT

Question

Hello: I have a program that allows me to copy many pieces of information to my clipboard and then paste each one individually or all automatically into another document. I tried using this withand it pastes the pieces of information just fine into each cell but it starts at A and then goes to Z. The problem is that I only want it to paste to three cells across (ABC)and then drop down to line #2 and go across again so that I essentially have a three column table of information. Specifically, each line will hold a first name (A), last name (B) and email address (C). Is there a way to lock out cells D - whatever so that information will not populate to that cell when the automatic pasting is occurring?

Answer

You can't copy 26 columns from some source and paste only 3 & have it wrap. You'd have to paste it as is and then, depending on the real layout of the information, you may need to use a macro to re-flow the data. Without more specific details, I can't say much more.


Question

Hello: I have a program that allows me to copy many pieces of information to my clipboard and then paste each one individually or all automatically into another document. I tried using this withand it pastes the pieces of information just fine into each cell but it starts at A and then goes to Z. The problem is that I only want it to paste to three cells across (ABC)and then drop down to line #2 and go across again so that I essentially have a three column table of information. Specifically, each line will hold a first name (A), last name (B) and email address (C). Is there a way to lock out cells D - whatever so that information will not populate to that cell when the automatic pasting is occurring?

Answer

although you can lock cells from being used, this would simply cause the paste to fail - if you have data in a tabular format, it will come across toin that format - what I would do would be to paste to a blank sheet, and then use either VBA or formulas to get the data you want from that sheet onto the destination area - if using formulas, you would then copy and paste special, values over the formulas to replace the formulas with values - in either case, once done, the blank sheet you used can be deleted.

Advertisement

©2017 eLuminary LLC. All rights reserved.