"Macro" that will pull data from one sheet to another sheet.

[robert220]

I'm extremely new to Macro's and I'm looking to pull multiple columns from one sheet to paste in another sheet. I've looked at other post but none really stuck out to me.
sheets are Raw Data and want to copy and past to sheet Inventory. I will be pulling columns from raw data A range 2:900 and same for columns B, C, D, E, F, G, H. and pasting to Inventory columns B-I.
Any Help would be appreciated.

 

[JLGWhiz]

Is this what you want

Sub t()
Sheets("Raw Data").Range("A2:H900").Copy Sheets("Inventory").Cells(Rows.Count, 2).End(xlUp)(2)
End Sub

 

[robert220]

Thank you JLGWhiz

 

[robert220]

JLGWhiz,
for some reason when i run the script it does what it's suppose to but starts with cell 496 down instead of B2

 

[Nanogirl21]

Please Try

Sub Update_Inventory()
Sheets("Inventory").Range("B2:I900").Value = Sheets("Raw Data").Range("A2:H900").Value
End Sub

This is basically copying infromatuob for Raw Data and pasting as values in Inventory.

 

[robert220]

Thank you that worked perfect.

 

[Nanogirl21]

You're welcome. Enjoy.

 

[JLGWhiz]

JLGWhiz,
for some reason when i run the script it does what it's suppose to but starts with cell 496 down instead of B2

Just for clarification. The reason the code posted the copied values beginning on row 496 was because there was already data on the Inventory sheet in the preceeding rows of column B. The code will post to a range beginning with the next available row of column B. The OP was not clear on whether you wanted to replace old data each time, or if there was existing data on the Inventory sheet.