Forum Discussion
skip hidden rows when copying INTO a spreadsheet
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.
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.
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.
- 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?