- Copying contents of a sheet
Re: Copying contents of a sheet
toggle quoted messageShow quoted text
While doing copy and paste through excel the spaces in between also gets copied and moved. However on the pasted data you can apply filter and un-select the blanks, then you are only left with cells with data but this too works on column by column basis.
Hope this helps!
I need to copy the contents of a sheet and paste the contents into another sheet in another workbook. The trick is that I do not know which cells in the sheet contain data.
Any suggestions on how to find out what range of cells have data. Then the best way to select that area to copy to the new sheet.
Any suggestions will be appreciated.
Thanks in advance,
Office: 4147783040 Extn:4063
445 S Curtis Rd West Allis, WI 53214
Industries for the Blind & Visually Impaired accepts no
liability for the content of this email, or for the consequences of any actions
taken on the basis of the information provided, unless that information is
subsequently confirmed in writing. If you are not the intended recipient, you
are notified that disclosing, copying, distributing or taking any action in
reliance on the contents of this information is strictly prohibited.
Join firstname.lastname@example.org to automatically receive all group messages.