Hi all, Im rather new at this Excel stuff, but I'm having a go and I've got stuck, I have a cell that gets its data many different sheets, special pasted with value. this same data then gets copied to another page where it needs to be stored permanently.
What I am looking for is a VBA way to say copy this to A1 but then save it there, and when the page gets updated save the next lot of data in A2. if that makes sense. Any help would be appreciated.
No it makes no sense to me. But I would like to help you if I can.
Please post "before" and "after"sheets
ie what the sheet looks like before you do anything, and what it loos like after
if this requires multiple sheets, then that is what we need
- please attach a workbook with a complete explanation
thanks
Does this data get copied to the same cell each time?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks