Previous Topic Next Topic

How to copy information from sheet 2 into sheet1

Closed
R28G Posts 6 Registration date Thursday March 1, 2018 Status Member Last seen March 8, 2018 - Updated on Mar 2, 2018 at 04:30 AM
 Blocked Profile - Mar 8, 2018 at 08:28 AM
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

Answer 1 / 1
Blocked Profile
Mar 2, 2018 at 02:59 PM
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 March 1, 2018 Status Member Last seen March 8, 2018
Mar 2, 2018 at 06:27 PM
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 March 1, 2018 Status Member Last seen March 8, 2018
Mar 3, 2018 at 09:39 PM
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
Mar 4, 2018 at 04:11 PM
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 March 1, 2018 Status Member Last seen March 8, 2018
Mar 4, 2018 at 09:09 PM
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
Mar 5, 2018 at 04:45 PM
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.