Previous Topic Next Topic

How to copy information from sheet 2 into sheet1

Closed
R28G Posts 6 Registration date Thursday 1 March 2018 Status Member Last seen 8 March 2018 - Updated on Mar 2, 2018 at 04:30 AM
 Blocked Profile - 8 Mar 2018 à 08:28
I have a spread sheet with two sheets.
The first contains names and i need to copy information from sheet 2 into sheet1.
in Sheet 1 F66 =Sheet2 A2
Sheet 1 F67=Sheet 2 A4
Sheet 1 F68 =Sheet 2 A6
etc
then other cells in sheet 1 with different patterns in sheet2.
Thanks in advance.
I am not a young member and used basic spreadsheets in the past but now need to do above for a project i am doing

Thanks for the Forum, my first Post
Related:

1 response

Réponse 1 / 1
Blocked Profile
2 Mar 2018 à 14:59
Take a look at this article:
https://ccm.net/faq/54862-how-to-copy-data-from-one-excel-sheet-to-another-using-a-formula

It goes over moving data to another sheet after qualifying it!

R28G Posts 6 Registration date Thursday 1 March 2018 Status Member Last seen 8 March 2018
2 Mar 2018 à 18:27
Thanks for your reply,its nice of you to take the time to help me. I will look at the article and let you know.Thanks again
R28G Posts 6 Registration date Thursday 1 March 2018 Status Member Last seen 8 March 2018
3 Mar 2018 à 21:39
Thanks again. unfortunately i am still a bit confused.in formulae can you clarify a few things please .At the begining FNC find last row (on what sheet0 do i put sheet2 then Cells(this Workbook.worksheet(on What Sheet)
so for example .Rows.countFor my eg i put Cells(This workbook."sheet 1" Then?
as i have said before i am a older dasic spred sheet user please bear with me if i find a bit difficult to understand everything.
Blocked Profile
4 Mar 2018 à 16:11
Please edit your post so I understand what you are asking. I understand the NEW touch methods are cumbersome, but so is reading a bunch of code!!!!
R28G Posts 6 Registration date Thursday 1 March 2018 Status Member Last seen 8 March 2018
4 Mar 2018 à 21:09
Thanks for your patience.
i don't understand where or what i need to enter. I have not used code before and am struggling to make sense of it.
Can you simplify to something like:
to shit data from sh 1 A1 to sh 2 A3 enter this info "here'? hopefully if i have one entry i can work out what i need to do with the rest.
Thanks again
Blocked Profile
5 Mar 2018 à 16:45
Findlastrow, accepts the variable for the worksheet that you want to place th edata onto. So if you wanted to find the last row of "sheet2", you would call: 

FindLastRow("Sheet2")


Pass the sheet to the fnc.

Similar discussions

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

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

1 response