VBA Worksheet data transfer

unhappydoughnut - Jul 31, 2017 at 11:21 AM - Latest reply:  Unhappydoughnut
- Aug 1, 2017 at 01:21 AM
hello,

I haven't done anything with code for years and I am so lost in this,

I have a table on sheet 1 which goes from A-J and 1-8221 and contains data of an item we use and we fill it out when we use an item and finish that line when it gets scrapped


what I need to happen is when the item gets scrapped and we update the spreadsheet is for it to automatically move that item over to the other spreadsheet on sheet 2 which is a table holding all the scrapped items data in it,

since there is so many of the items on sheet 1 we have manually put all the scrapped ones over to sheet 2 which currently goes from A-J and 1-1584 as that's all the scrapped ones,

if someone could let me know what to do to make this automatically move them over that'll be great
See more 

Your reply

5 replies

ac3mark 9964 Posts Monday June 3, 2013Registration dateModeratorStatus July 19, 2018 Last seen - Jul 31, 2017 at 04:48 PM
0
Thank you
Post some code where you are stuck. There is no sense in us re-writing what you have already worked on, so post and we can help out.
Respond to ac3mark
Unhappydoughnut - Jul 31, 2017 at 05:06 PM
0
Thank you
When I say I'm lost I mean I opened up to do some coding and ended up staring at the blank screen as my mind went completely blank
ac3mark 9964 Posts Monday June 3, 2013Registration dateModeratorStatus July 19, 2018 Last seen - Jul 31, 2017 at 05:08 PM
Can you wire frame the process and how you wish to see each event (don't worry about syntax at this point, lets see if the program logic will do at this point)?
ac3mark 9964 Posts Monday June 3, 2013Registration dateModeratorStatus July 19, 2018 Last seen - Jul 31, 2017 at 05:11 PM
I am stepping sway for a few minutes, so take your time.
Respond to Unhappydoughnut
Unhappydoughnut - Aug 1, 2017 at 01:21 AM
0
Thank you
Literally have no idea what you're on about, when I did do things with code in the past it was basic stuff for a day or two,

All I need is if you imagine what the chart looks like from what I said in the OP

The last Collum is a scrapped date and what I need is for when a date gets put into scrapped (and not into date used) it'll put it into the other table on sheet 2
Respond to Unhappydoughnut