Dear all,
I have sheet1 and sheet2.
Sheet1 has filtered cells/rows (Out of 2000 cells, only 200 are visible).
I am copying equal number of rows i;e 200 from sheet2 (With some values) and trying to paste it against the visible 200 rows in sheet1 (Say in Column B).
Because sheet1 is filtered, all 200 values doesnt get pasted in sheet1.
Any solution to paste these values on visible 200 cells in sheet1??
Thanks for your help.
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Refer the attachment.
In INPUT sheet, filter column C by 7 value, copy all the values below and try to paste it in B column..
It will not replace 5 completly as it is filtered..(Refer OUTPUT sheet for sample)
I want VBA code to replace 5 with 7 while pasting.
Thanks
Still have queries or doubts about my requirement...?? Any updates plz..??
Give it some time.......
attaching workbooks to your original question would have saved a lot of time, and somebody would have started working on it right away.
Sorry for that...I will wait..No problem..
Dear all,
Can anyone please confirm if anyone is working on my concern...??
Thanks.
Here's 2 options, using a loop or using the filter.
Please Login or Register to view this content.
Thats awesome....Thank u very much...
Hi davesexcel,
Plz find the attached sheet.
Can you please provide me the code to paste all the random values from OUTPUT sheet, Column B:B onto INPUT Sheets Column B:B.?
This is what my real scenario is...
Please note, Input sheet as filtered values and there is not specific criteria of it.
Last edited by mchilapur; 01-15-2015 at 09:09 AM.
Your original question and the "real" question is not even close.Originally Posted by mchilapur
......
This is what my real scenario is...
Please note, Input sheet as filtered values and there is not specific criteria of it.
Dealing with your real question!
What is supposed to happen?
Hi mchilapur,
. This is one Thread I have been following and learning from the supplied codes over the last couple of days.. (Thanks davesexcel)
.
despite this, I cannot make head or tail of exactly what You want .
How about
. 1 ) cut your example data down to about 40 (We can see all that amount easily without scrolling up and down)
. 2) Supply two workbooks.
. One should have good representative data of all the typical scenarios
. the other should simply look exactly as you want your first workbook to look like after running any code we give you, based on the actual example data you give us in the first workbook
Alan
I agree its my mistake....Even I was thinking why didnt I post this question at the beginning itself...Heartfull sorry...
Shall I post this request on new thread or shall I look forward for the answer here..??
I will do as you say...Sorry again.
Who are you talking to? Me (Alan) or Dave or Both.
. I (Alan) am new here, but as I understand it: - ....
. If you are asking something different from your original request, then ..
... YES - start a new thread BUT reference this one by including a link to this Thread. –
. At the start of the Thread write something like……
“This is a follow on from this Thread.:
http://www.excelforum.com/excel-prog...ells-only.html
…… etc etc.."
. Whatever you do.... Attatch clear files as I (Alan) explained in post #12 .
. - I still have no idea of exactly you want:
. Remember “A picture paints a thousand words”
- So simply show a Workbook how it looks Before and how it should then look After running any macro.
. AND BE Patient. You have already had a lot of help which might have been wasted effort on Dave's behalf. Everyone works voluntarily here – you should not expect an answer too quickly. I will definitely do it for you tomorrow if no one else picks it up in the meantime but only if you provide the extra info I asked for. (And PM (Private Message) me if you do start a new Thread giving me the link to it – If you do not know how to do a PM , then check out the Forum Rules and FAQ (Click above on Forum Rules or FAQ) – you should do all that anyway before posting!!)
Alan
Last edited by Doc.AElstein; 01-16-2015 at 11:12 AM. Reason: Typo
Ok...Thanks 4 ur feedback...I will start a new thread shortly.
I have marked this one as SOLVED.
Below is the follow up thread:
http://www.excelforum.com/excel-prog...-new-post.html
Last edited by mchilapur; 01-17-2015 at 12:56 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks