VBA code for pasting rows into another sheet based on a date condition

**lewiem** · 06-06-2016, 03:32 AM

Hi All,

I am relatively new to programming and writing codes and require some guidance with my latest problem.

I have a spreadsheet that has an input button on the first sheet. This button copies the data inputted into varies cells based on a name condition (Range("M21") = Application.UserName) and pastes into the second.

The code then paste's the data into the relevant column based on the name. I have a list of dates down column A (sht. 2) to record the data inputted into the relevant data row. I am not sure how do go about creating code to match the data to that in column A for it to then paste into that row.

hope this makes sense...

thanks

**zbor** · 06-06-2016, 03:36 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

VBA code for pasting rows into another sheet based on a date condition

LinkBack

Thread Tools

Rate This Thread

Display

VBA code for pasting rows into another sheet based on a date condition

Re: VBA Code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Represent (define?) a section of code with a variable (shorten long code lines)?

[SOLVED] Need help with VBA code. Tons of code seperated in two, second part of code doesn't work.

[SOLVED] Pattern Building VBA Code - Working code, would like to use cleaner code

[SOLVED] Excel VB code. Message pops up while code running asking question. Code must not wait.

[SOLVED] VBA code for assigning a numeric code to text; then numeric code populates table

[SOLVED] Pick up the Vendor code of a part code from looking the highest Qty of a part code

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions