Forum Discussion

Deleted

Nov 26, 2021

Solved

skip hidden rows when copying INTO a spreadsheet

I work with a lot of statistics, and was just wondering if it was possible when I paste some random statistics into a spreadsheet with active filters, how to not do it in the hidden rows. To make...

excel

Macros and VBA

training

Juliano-Petrukio
Nov 26, 2021
Deleted
I would suggest you using a formula to get these "NEW" values and then you can copy and paste special after apply the following formula.
Lets say product values (Product Name, Product Price) in a table with ~3k different products.
=INDEX(ColumnContainingNewPriceValues, MATCH(ProductName,ColumnContainingProducts,0),1)
By doing it, you will get the "New Price value" in an auxiliar column and you can after copy and paste special these values.

Juliano-Petrukio

Bronze Contributor

Nov 26, 2021

I guess would be easier if you paste the values in the last available row so by doing it you will not jeoardise your actual data there.
The other option would be unfilter the data and paste it accordingly.

Deleted

Nov 26, 2021

Juliano-Petrukio

okay let me rephrase that, so it may make some sense, as to why i would need that.

I have a table, with 2-3k rows filled with prices, which are ALL unique. Now, I want to add prices, of Something/Someone, but to know WHICH prices I am adding, I filter out which i dont need. to paste the "NEW" prices next to the old ones.

I sure as hell dont want to look up all rows one at a time and copy prices inside, as that takes hours, for just 1 addition.

Juliano-Petrukio
Bronze Contributor
Nov 26, 2021
Deleted
I would suggest you using a formula to get these "NEW" values and then you can copy and paste special after apply the following formula.
Lets say product values (Product Name, Product Price) in a table with ~3k different products.
=INDEX(ColumnContainingNewPriceValues, MATCH(ProductName,ColumnContainingProducts,0),1)
By doing it, you will get the "New Price value" in an auxiliar column and you can after copy and paste special these values.
- Deleted
  Nov 29, 2021
  This is already looking promising, but, what IF, the whole sheet is a calculated Table, and there is only one column I can Paste in, beacuse the rest is copy/paste/edit protected?