Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Formula for counting rows and doing a fill in afterwards
Hello
We are copying data from a worksheet in workbook#1 into a workbook#2 with a macro in it and into Worksheet A specifically of that workbook #2. While in a Macro fo workbook #2............... I need to figure out how many rows of data there is in worksheet A. This can vary from week to week. I than want to use that number to start in worksheet B and do a fill down starting in Row 2 of worksheet B and fill down columns A, B, C, D, E, and F for that many rows. Row 2 of worksheet B has formulas that I need to fill down with. Those formulas are in column A,B,C,D,E,F of row2. Also, I need to identify the #NA and for specific task names I need to change field E and F to specific values. Maybe I can do that with another macro inside the workbook Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill down formula incrementing by every 12 rows | Excel Discussion (Misc queries) | |||
Counting Rows - Fill ??? | Excel Worksheet Functions | |||
Macro or Custom button to fill in the same formula | Excel Worksheet Functions | |||
formula will not fill correctly due to odd number rows | Excel Worksheet Functions | |||
Fill Formula - Macro | Excel Discussion (Misc queries) |