Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different Sized Reports
Hi
I work in Manufacturing and explode stoppage analysis reports from our ERP to Excel for our machinery on a daily basis. I have written a macro for summarising the info and formatting which saves me time however; the reports vary in size from day to day. I have created a column which sums the contents of the next two columns i.e =e2+f2 and using the macro record function I dragged this formula down a couple hundred rows to cover the report I was using to create the macro but this leaves 0 rows on days when the report I am running is not very large. Is there a formula I can use with the macro to only add the contents of e + f column when there is data there to add? so the report can be as large or small as it likes and my macro will still work Much Appreciated Brian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Different Sized Reports
Dim rng as Range
set rng = Range(Cells(2,"F"),Cells(rows.count,"F").End(xlup) ) rng.offset(0,1).Formula = "=E2+F2" -- Regards, Tom Ogilvy wrote in message oups.com... Hi I work in Manufacturing and explode stoppage analysis reports from our ERP to Excel for our machinery on a daily basis. I have written a macro for summarising the info and formatting which saves me time however; the reports vary in size from day to day. I have created a column which sums the contents of the next two columns i.e =e2+f2 and using the macro record function I dragged this formula down a couple hundred rows to cover the report I was using to create the macro but this leaves 0 rows on days when the report I am running is not very large. Is there a formula I can use with the macro to only add the contents of e + f column when there is data there to add? so the report can be as large or small as it likes and my macro will still work Much Appreciated Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum different sized (employee) teams | Excel Worksheet Functions | |||
How do I sum different sized ranges? | Excel Worksheet Functions | |||
Row numbers have been re-sized | Excel Discussion (Misc queries) | |||
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report | Setting up and Configuration of Excel | |||
Printing a legal sized document on letter sized paper | Excel Programming |