LinkBack URL
About LinkBacks
How could I edit this code to copy and vaste the values in a6 and b6 into a7 onwards only if the value in c6 onwards is not blank. I tried running this code but could not get it to work. Many Thanks
Please Login or Register to view this content.
How could I edit this code to copy and vaste the values in a6 and b6 into a7 onwards only if the value in c6 onwards is not blank. I tried running this code but could not get it to work. Many Thanks
Please Login or Register to view this content.
Try this.
Please Login or Register to view this content.
Regards,
Khaled Elshaer
www.BIMcentre.com
Remember To Do the Following....
- Thank those who have helped you by clicking the Star below their post.
- Mark your post SOLVED if it has been answered satisfactorily:
- Select Thread Tools (on top of your 1st post)
- Select Mark this thread as Solved
it said invalid next control for rCell. Should i Dim rcell as string?Thanks
Please Login or Register to view this content.
this did not work. it only copied a5 and b5 and pasted it in a6 and b6. Also I forgot to mention that the data in C column is numbers. Many thanks
I dont think I can understand your request at the first place.
Please upload the file and try to describe more.
Thanks. I have uploaded the file I am working with. Basically, I am trying to automate data extraction from the data tab to the report tab. So far, I have automated the EIN, but I am trying to fill in the dates in the beg and end columns only if the EIN is not blank.many thanks
Here you go
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks