Upgrade your account to a Community Supporter account and remove most of the site ads.

Reply to thread

Message: <blockquote data-quote="Oryan77" data-source="post: 3516955" data-attributes="member: 18701">Ok, I know I could post this question on an Excel forum. But that would involve me registering on the website and creating a username/pword. I'm lazy today (and at work  <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":p" title="Stick out tongue    :p"  data-smilie="7"data-shortname=":p" />  )Is anyone here good with Excel? I have Excel 2003 and I have multiple tabs in 1 workbook. On tab A I have a list of info with dollar amounts in a column next to the list. On tab B I have the same info but I used the formula ( =tabA!G1 ) so it shows the same dollar amounts in the column on tab A. The rows are also in a different order than they are on tab A.My problem is, I would like to copy and paste that info from tab B into more colums on tab B. But when I copy and paste, the new colums formulas change the formula to ( =tabA!D1). However many columns over I paste, that determines what column in tabA the formula is set to.Is there a formula to use so no matter where I paste the cells it will always keep referring to the same column/cells in tab A?---------------------------I also have another question. I would like to be able to type a number in a cell and have the cell automatically add the letter x infront of the number after I'm done typing. Is this possible?Thanks for any help  <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile    :)"  data-smilie="1"data-shortname=":)" /></blockquote>

Verification