I have created one row of 737 columns. Basically, i had to convert a well formatted data entry sheet into one row so that it can be uploaded to a work database.
After creating my one row of 737 columns, I now have discovered that I did not make my references absolute. Thus, when I copy row one, the origin of my reference changes to the next row when pasting on the next line.
my first row, where cell F9 is the proper reference:
=IF(ISBLANK('ESA Timesheet'!F9), "", 'ESA Timesheet'!F9)
my second (pasted row), where the reference still needs to be F9, or more accurately $F$9:
=IF(ISBLANK('ESA Timesheet'!F10), "", 'ESA Timesheet'!F10)
Is there a way i can avoid putting in four $s in each of my 737 cells? all the references are in place, i just need to stop the automatic adjustment to the next row, as a relative reference would allow.
Bookmarks