hello everyone this is Al Rodgers and today I'm gonna show you how to transfer
a worksheet from one Google Docs to another I'm gonna show you two methods
I'm gonna show you the quick method method and I'll show you a longer
message okay so let's go ahead and get started here
this is a document a spreadsheet called the 30-day 30-day activity tracker as
part of a 30-day challenge series that I'm doing with my team and I want them
show them how to transfer this week to to their copy so this is a master copy
they cannot edit you can only view it so everyone has a copy of the original
document which only had week 1 so now we're in week 2 so I want to show you a
quick way to copy week 2 into your document now one thing I want you to
note at the top it says copy of 30-day challenge this is your copy that you
made earlier okay so don't get confused the master with the copy ok so here we
go I'm going back to the master I'm going down to where has week 2 which of
course is not on the copy see it says week 1 only so we're gonna go back to
the master we're gonna go down to week 2 and you'll see this arrow right here you
click on the arrow when you click on the arrow you'll see it up you'll see a menu
that pops up and one of the options says - copy - so I'm gonna say copy - now
it's asking me where do I want to copy this - I want to copy this - the one
that says copy of 30-day challenge it's our demo this is the one that's appeared
but I'm gonna copy it here so I want to do is I'm gonna copy to the spreadsheet
and say select it says she copied successfully success copying worksheet
okay it says open and target workbook now I can click on that it's gonna
probably bring up another copy of this I'm gonna say okay so now when I go over
here to the copy you'll notice that I'm gonna hit refresh and if everything
works out like we would like there should actually be a day two inside of
the copy okay so here it goes right here copy of 30 DC week two so now that you
have that in here you can literally just go ahead and let's modify a little bit
I'm just gonna so it doesn't say copy anymore and then you can literally take
this tab or by the way to make changes just double click on it alright I'm
literally gonna take this tab and move it over and now I can begin week two
that's the simplest and easiest way to
transfer a worksheet from one spreadsheet to another the other method
which you know what I'm not even gonna mess with the other method was actually
copy and paste I mean you can literally go over here but it's really kind of
messy because you have to delete stuff so you know I'm gonna go ahead and to
share that one way to do it I think that's the best way to do it it's the
most effective it's the most efficient way to do it so let's just stick with
that one way instead of doing the second way which is copy and paste so we're
just gonna leave that alone so if you have any questions feel free to reach
out to me hopefully this is helpful hopefully you guys are doing a good job
for week one to week two and able to keep track of your activity see because
at the end of the day consistent action equals results okay once again I'm Al
Rogers born to grow ready to serve until next time see you later bye for now
Không có nhận xét nào:
Đăng nhận xét