5 Replies - 163 Views - Last Post: 03 December 2018 - 06:02 AM Rate Topic: -----

#1 Ani.   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 03-December 18

fill sheet from another sheet

Posted 03 December 2018 - 05:26 AM

Hi, can anybody help me? I must fill row from the coloumn of another sheet. Please help me. I tryed many times baut I can't
Is This A Good Question/Topic? 0
  • +

Replies To: fill sheet from another sheet

#2 Ani.   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 03-December 18

Re: fill sheet from another sheet

Posted 03 December 2018 - 05:36 AM

I'm programmer: c++, a little java but i cant understand sintacsis of vba.
Was This Post Helpful? 0
  • +
  • -

#3 andrewsw   User is offline

  • dependency injected
  • member icon

Reputation: 6668
  • View blog
  • Posts: 27,308
  • Joined: 12-December 12

Re: fill sheet from another sheet

Posted 03 December 2018 - 05:44 AM

Provide a clearer, fuller, description and your most recent code attempt.
Was This Post Helpful? 0
  • +
  • -

#4 Ani.   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 03-December 18

Re: fill sheet from another sheet

Posted 03 December 2018 - 05:53 AM

Sub fil()
Dim i As Long, lastrow As Long
i = 2
lastrow = Sheets("sheet1").Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To lastrow
 ActiveCell.FormulaR1C1 = "=Sheet1!R[i]C[1]"
    Next i
End Sub


This is the last code I've tried, but I try since yesterday and every time it gives errors

This post has been edited by andrewsw: 03 December 2018 - 05:56 AM
Reason for edit:: added missing code tags

Was This Post Helpful? 0
  • +
  • -

#5 andrewsw   User is offline

  • dependency injected
  • member icon

Reputation: 6668
  • View blog
  • Posts: 27,308
  • Joined: 12-December 12

Re: fill sheet from another sheet

Posted 03 December 2018 - 05:59 AM

Please wrap code in code tags, I have added them for you this time.

If there are errors then provide the error details.

Two things I notice, you cannot embed "i" into a string that way, you need to construct (to concatenate) the formula. If you used "helloithere" the i will not be substituted. And you do not attempt to set the ActiveCell nor to change it. It will be wherever the cursor was last active.
Was This Post Helpful? 0
  • +
  • -

#6 Ani.   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 03-December 18

Re: fill sheet from another sheet

Posted 03 December 2018 - 06:02 AM

Thank you I'll try
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1