Copy and Paste Filtered Cells

[gregorydigiovanni1]

I thought I was an above-average Excel user but apparently not. I have a spreadsheet with about 3000 rows. I have these filtered to 115 rows and wrote a description using concatenate for these 115 rows. I'm now trying to paste these concatenated cells as values to where they belong but I get an error each time. I tried to use Visible Cells Only but that didn't work either.

Any help will be greatly appreciated!

MS Office Professional Plus
Excel 2010

 

[James Snyder]

I don't understand what you mean by concatenating the rows, but here is how I copy and paste discontiguous areas into a combined range:

.SpecialCells(xlCellTypeVisible).Copy
Set filtSheet = Sheets.Add(After:=Sheets(1))
filtSheet.Name = fltShtName
filtSheet.Paste

 

[gregorydigiovanni1]

Hi James - thanks for the quick reply. In column G I have an export of outdated HTML meta descriptions & keywords similar to

****** name="Description" content="Browse our entire collection of great products. Fresh to your door, 100% guaranteed"/>****** name="Keywords" content="keyword1, keyword2"/>

<tbody>
</tbody>

In Column I, there is the concatenate formula similar to

=CONCATENATE("****** name=""Description"" content=""Browse our ",A111," great products. Arrives fresh in a protected box, 100% guaranteed. See why over 10k people Like us""/>","****** name=""Keywords"" content=""keyword1,",LOWER(A111),"""/>")

I want to take the formulas in Column I and paste them as values in Column G so I can then massively update a website w/ the CSV file.

Hopefully that makes more sense!

 

[James Snyder]

It does. I haven't a clue, but found some references:
excel vba - Using ranges, how can I make a .COPY DESTINATION paste as VALUES - Stack Overflow
http://www.mrexcel.com/forum/excel-...s-copy-paste-cell-value-only-not-formula.html
http://www.mrexcel.com/forum/excel-...-applications-pastespecial-format-values.html