blastpwr1970
06-04-2006, 06:35 AM
Hi all,
This is my first post, Help!
Am I just started getting my feet wet with VBA, please help, I don't know much about programming.
First Problem!
I need to get the value from the interception of "Look2" and "Test3" but the location of "Test3" keeps changing every day because data gets added every day by an automatic report update, also the file name changes from 5/31/2006 to 6/1/2006 has data gets updated, By the way the "Test3" name does not change nor the "Look2" name.
I need to copy these value everyday to a new workbook in a different directory.
---------------Look1 ---- Look2 ----- Look3 ------ Look4 ----- Look5
Test1
Test2
Test3 -------------------- This value
Test4
Test5
Second Problem!
I need to copy certain rows with certain text to a new sheet but only partial text is know under "Look3", the copy need to meet the condition of "TRUE" and the "partial text" for that row.
-----------Look1 ------- Look2 ------- Look3 ----------------------------------- Look4 ------- Look5
Test1
Test2 ------------------- TRUE ------- (This txt) *with this unknow*
Test3
Test4 ------------------- TRUE ------- (This txt) *with this unknow*
Test5
Any tutorial links for VBA will help a lot too.
I hope, I can also contribute to the forum in the near future.
Thank you for all your help in advance.
This is my first post, Help!
Am I just started getting my feet wet with VBA, please help, I don't know much about programming.
First Problem!
I need to get the value from the interception of "Look2" and "Test3" but the location of "Test3" keeps changing every day because data gets added every day by an automatic report update, also the file name changes from 5/31/2006 to 6/1/2006 has data gets updated, By the way the "Test3" name does not change nor the "Look2" name.
I need to copy these value everyday to a new workbook in a different directory.
---------------Look1 ---- Look2 ----- Look3 ------ Look4 ----- Look5
Test1
Test2
Test3 -------------------- This value
Test4
Test5
Second Problem!
I need to copy certain rows with certain text to a new sheet but only partial text is know under "Look3", the copy need to meet the condition of "TRUE" and the "partial text" for that row.
-----------Look1 ------- Look2 ------- Look3 ----------------------------------- Look4 ------- Look5
Test1
Test2 ------------------- TRUE ------- (This txt) *with this unknow*
Test3
Test4 ------------------- TRUE ------- (This txt) *with this unknow*
Test5
Any tutorial links for VBA will help a lot too.
I hope, I can also contribute to the forum in the near future.
Thank you for all your help in advance.