Forum Discussion
Copying entire Column then inserting copied cells (column) takes 10-15 minutes to complete???
Hello. I have a spreadsheet with a column or two that I need to shuffle around. This column is largely empty from a data perspective. It does have a number of formulas and conditional formatting in p...
It sounds to me like the basic design--into which this whole procedure has been fitted--is what might need to be reexamined.
So before posting the actual workbook--that image doesn't really tell us much--why don't you describe the business context here? To the extent that you can do this without violating confidentiality or proprietary details, describe what the spreadsheet is all about in the first place. Such things as:
- What kind of data are you working with?
- What are the inputs?
- What are the outputs?
- What sort of processing of inputs is needed in order to produce the output?
- (Presumably this is where that column manipulation fits.)