Just starting to learn VbA and I have this simple problem. At least I think it's simple.
I have a raw data sheet that I update. If something is completed I put the date in one if the columns. How do extra the row and display it in another sheet. Say that the completed date is today I want to creat a she that has the data from that day. Then another sheet with data from the next day.
Is that clear, is that possible?
Post a sample workbook.
You need a sheet specific macro.
That Macro will run whenever you modify your spreadsheet. If a date is added it will call another macro.
The second Macro will create a copy of your data sheet and rename it to include that date.
It will then clear the data on the original sheet.
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the adress bar)
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
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