Forum Discussion
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 it more clear, say I am copying a range of values B1:B15 (there are no hidden rows in this range) from Sheet1. Now I have another sheet, Sheet2 in which say rows 10 thru 15 are hidden. So if I select D1 on Sheet2 and paste the copied range, then range D1:D15 will be filled with the copied values i.e. the hidden range of D10:D15 also got filled with the values. Now what I want is that instead of the hidden range of D10:D15 being filled up, I want to skip that range and fill up D16:D20. So the range D10:D15 should be skipped when pasting the values.
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.
4 Replies
- 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.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.