Moving data to another cell automatically - extended

[Krix]

Hi,

I was wondering if someone can help me on my problem.

Sheet1: TaggingInfo
Sheet2: ModerationInfo
Sheet3: Tagging
Sheet4: Moderation

The scenario is:
I'll paste the info's that I get on Sheet1 (such as "Media ID, Username, Title, Date") Once I pasted it. It will automatically copy and move it on Sheet 2 on put it on designated columns, also I only need to copy and move the Username, Media Id and Date and after successfully copying the info's on Sheet3 a confirmation will be prompt and say its successfully copied and will delete the info's pasted on Sheet1. So that it can make a new entry again and will automatically move to the next row.

Same goes with Sheet2, If I paste information (such as Username, Media ID and Flagger. ) I want it to move on Sheet 4 on their designated columns.

Previously I was helped by Sir @arlu1201 and gave this code, now I want to change some stuff and add new functions on the Tracker that I'm working. I'll attached the sample Spreadsheet that I made.

I did tried to tweak the code and read on it but still I always get errors. etc etc.. Can someone please help and by any chance teach me a little about the code lines that you put so that in future I wont bother you guys

Please Login or Register  to view this content.

Any help will be much appreciated. Thanks!

Krix

[jkj115]

First thing is your sheet names in the code don't match you actual sheet names. So you need to replace "Sheet2" with "ModerationInfo" (if Sheet2 is actually ModerationInfo). Its ahrd to understand what you need when the sheet names in the code don't match your actual sheetnames

[Krix]

Hi!

Thanks for the reply. The code that I quoted was just a sample code that arlu made. So basically it doesn't really match

- Krix

[arlu1201]

ModerationInfo seems to have 9 fields which need to be copied. But Moderation has only 3. How do you want to proceed?

What changes do you want done to the above code? Just add the code for the Moderation sheet?

[Krix]

Hi,

Sorry for the confusion. What I mean is that If I paste the info's in ModerationInfo such as (Username, User Id, User link etc etc.) it will automatically move the Username, Media Id and Flagger on Moderation tab. Just like with Tagging.


On the other hand, what I want to be changed on the code above is just that replace the Video title with Media ID. I don't want the Video title be moved on the Tagging Tab what I need now is Media ID.

THANKS!
-Krix

[arlu1201]

So you want all information from the Moderation Info tab to be moved to the Moderation tab like how its done for the Tagging tab?

And the existing Tagging code should be changed to show that the Media ID is reflecting on the Tagging tab instead of Title?

[Krix]

Yes that is correct..

Thanks!
-Krix

[arlu1201]

Try this updated code

Please Login or Register  to view this content.

[Krix]

Sorry for the late reply Sir.
When I ever run the macro then looked at Media ID (Tagging tab only) it shows #VALUE error.
- I think the problem is because Tagging and Moderation has different type set on Media ID. (Tagging tab has 'Media Id' while Moderation tab 'Media ID:"

Also on both of tabs is it possible to remove the '(Weight: 1)'on Media ID? -Sometimes the value of Weight is 0


Thanks!
Krix

[arlu1201]

Oops i forgot to mention that you need to ensure that each label has the ":" after the text so that the macro works fine.

Where is Weight: 1 given?

[Krix]

Hi,

Can we just make a separate code for Tagging tab? Coz I always paste info with this format on media ID (Media Id97c409b6-9952-48f2-884f-9a761123d32e "what I just needed is the code and I want to erase the Media Id").


Weigh: 1 is given on ModerationInfo tab. Is it possible to remove that when it moved on Moderation tab?

Thanks,
Krix

[arlu1201]

You didnt mention anything about erasing the media id. You said you would like to copy the data onto the next sheet by excluding the text before the ":". However, in the 2nd page you had 2 columns instead of 1 like the previous page. So i directly got that data to transfer to the respective info page.

[Krix]

Oh Sorry. I'm very sorry bout that. So is my request possible?

Krix

[Krix]

Also, where can I put these codes?

So that it will automatically removes hyperlinks.

Please Login or Register  to view this content.