Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Paste Link Function
Is there a way to be able to copy the paste link function where the cell
below automatically increments the cell number? (I.e. "=Monthly!$A$27" copy to cell below "=Monthly!$A$28") Thanks! |
#2
|
|||
|
|||
Naive,
If you mean you're copying that formula, take out the $ signs. That makes it a relative cell reference, not absolute as it now is. -- Earl Kiosterud www.smokeylake.com "naiveprogrammer" wrote in message ... Is there a way to be able to copy the paste link function where the cell below automatically increments the cell number? (I.e. "=Monthly!$A$27" copy to cell below "=Monthly!$A$28") Thanks! |
#3
|
|||
|
|||
Take the $ signs out of "=Monthly!$A$27" so it becomes "=Monthly!A27", then
copy. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "naiveprogrammer" wrote in message ... Is there a way to be able to copy the paste link function where the cell below automatically increments the cell number? (I.e. "=Monthly!$A$27" copy to cell below "=Monthly!$A$28") Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
how do i use the function to copy and paste a determined variable. | Excel Worksheet Functions | |||
Paste link versus allowing two cells equal each other? | Excel Discussion (Misc queries) | |||
Paste a chart as a link? | Charts and Charting in Excel |