VB question
Closed
Hio3499
-
Dec 5, 2011 at 08:32 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 5, 2011 at 01:56 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 5, 2011 at 01:56 PM
Related:
- VB question
- Yahoo mail forgot password and security question - Guide
- Google recovery password security question - Guide
- Vb editor download - Download - IDE
- Mom’s secret question - Guide
- Vb select case - Guide
2 responses
So basically what i need is a code that searches doc 1 for data in column A & B and copies where column E is not null.
Select * from config log
where A=1234 and B=Red and E is not null
copy A, B, E from config log
paste into template.
Select * from config log
where A=1234 and B=Red and E is not null
copy A, B, E from config log
paste into template.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 5, 2011 at 11:40 AM
Dec 5, 2011 at 11:40 AM
You can apply filter
copy the visible rows
paste the rows where you want
copy the visible rows
paste the rows where you want
Well for worksheet one there is about 400 rows and i really only need about 80 rows of data. I had set up macro's to copy specific rows but the problem is when new rows are added i dont pull the right information. Thats why i am trying to use a search/query that picks specific values from column A, B and F and pastes them onto my parts template.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Dec 5, 2011 at 01:56 PM
Dec 5, 2011 at 01:56 PM
could you explain what you meant by " i dont pull the right information". May be better would be if you could post a sample workbook at some public file share site and post back the link to the file back here, it might be easier for you to show issue and for some one to suggest a solution
What I was trying to say was, if you can manually filter the data as you want, you can code it to do the same too. If for some reason you cannot manually fitler the data (example, i need 3 possible values for A etc) then one can come up with a workaround.
What I was trying to say was, if you can manually filter the data as you want, you can code it to do the same too. If for some reason you cannot manually fitler the data (example, i need 3 possible values for A etc) then one can come up with a workaround.
