Formulas

[alisonshikles]

Hello,

I am pulling information from a website.  I want to paste the information in one tab and automatically pull that data into specific columns in another tab.  I tried the = command however when I try to copy it down the reference changes.  How can I do this without the reference changing? I tried grabbing the whole column, enter the formula in the function bar but the reference still changed. Example:

I want each formula in column A in Sheet 1 to pull the information from Sheet 2 A1. 

Thank you in advance!!!!!

[#2]

@alisonshikles

Replace A1 with $A$1, this makes A1 hardcoded and you can copy down the formula 

[#3]

@PascalKTeam 

Thank you so much!!!!!