Thank you very much for the replies, they were extremely helpful! However I have 2 questions.
First, I understand the basics of the above code and have revised it somewhat to work on a practice sheet, however when I move it into my "action workbook" and revise where necessary it stops...
I haven't had formal training in Excel and I have taught myself from the ground up. However I am familar with using VBA and Macros, recording Macs, and revising VBA to have Excel do what I need it to. At this point I have them automaticaly emailing, feeding info from workbook to workbook...
Okay, I think I either don't understand the solution or I haven't explained my problem very well. The solution in the FAQs doesnt seem like it will take the information and place it in a pre-designated cell if empty only on command.
I have three columns and several rows, these rows are...
Hi there I am new to tek-tips so I hope my question will make sense to everyone...I am using Excel 2003 and have an extensive set of workbooks capturing stats for work. One of the workbooks needs to automatically copy certain information(located in a range of data), PasteSpec Values only at the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.