Previous Topic Next Topic

VBA Worksheet data transfer

Closed
unhappydoughnut - Jul 31, 2017 at 11:21 AM
 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

3 responses

Answer 1 / 3
Blocked Profile
Jul 31, 2017 at 04:48 PM
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.
Answer 2 / 3
Unhappydoughnut
Jul 31, 2017 at 05:06 PM
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
Blocked Profile
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)?
Blocked Profile
Jul 31, 2017 at 05:11 PM
I am stepping sway for a few minutes, so take your time.
Answer 3 / 3
Unhappydoughnut
Aug 1, 2017 at 01:21 AM
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

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Copy data from one Excel sheet to another: automatically
gannesh0604 -
vcoolio -

10 responses
Extract data from one sheet to another
phanikr -
Mazzaropi -

1 response
How to extract data from one excel file to another
zamorin -
zamorin -

2 responses