| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find end of column and paste formula in adjacent colmn
If I have 3 rows of date in columns A and B, but then add two more
rows (and in future will be regularly adding rows), like this... A B C 1 1 2 Formula 2 1 2 Formula 3 2 1 Formula 4 1 2 5 2 1 ....Can I write a macro that finds the end of column A and B, and then copies the formula in column C down to the end of data in A and B? Thanks in advance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find end of column and paste formula in adjacent colmn
How does this differ from the question you posted earlier today???
-- HTH... Jim Thomlinson " wrote: If I have 3 rows of date in columns A and B, but then add two more rows (and in future will be regularly adding rows), like this... A B C 1 1 2 Formula 2 1 2 Formula 3 2 1 Formula 4 1 2 5 2 1 ....Can I write a macro that finds the end of column A and B, and then copies the formula in column C down to the end of data in A and B? Thanks in advance! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find end of column and paste formula in adjacent colmn
It doesn't. I thought that earlier post had been removed.
On Aug 9, 5:34 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move- This-.com wrote: How does this differ from the question you posted earlier today??? -- HTH... Jim Thomlinson " wrote: If I have 3 rows of date in columns A and B, but then add two more rows (and in future will be regularly adding rows), like this... A B C 1 1 2 Formula 2 1 2 Formula 3 2 1 Formula 4 1 2 5 2 1 ....Can I write a macro that finds the end of column A and B, and then copies the formula in column C down to the end of data in A and B? Thanks in advance!- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
| Find end of column and paste formula in range | Excel Worksheet Functions | |||
| Lookup date on multiple worksheets, total amts for adjacent colmn | Excel Discussion (Misc queries) | |||
| summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
| HELP: need to find number and sum another colmn | Excel Programming | |||
![briandhowells@gmail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
