| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to write a macro??
I have 2 workbooks. One I log in soils and plants with for different tests.
I click on generate labslips (macro) and it opens another workbook that lists all the corresponding numbers with the test that I do. When I look at labslips I could have 25 plants in a row for a NO3n test but then it will be blank for maybe 15 or 20 spaces until my next set of numbers come. How do i write a formula or macro that will get rid of empty spaces so i don't waste alot of paper? Thanks for any Information or help. Keith |
|
#2
|
|||
|
|||
|
you could sort by that column with the numbers, blanks would go to the bottom
"Keeter" wrote: I have 2 workbooks. One I log in soils and plants with for different tests. I click on generate labslips (macro) and it opens another workbook that lists all the corresponding numbers with the test that I do. When I look at labslips I could have 25 plants in a row for a NO3n test but then it will be blank for maybe 15 or 20 spaces until my next set of numbers come. How do i write a formula or macro that will get rid of empty spaces so i don't waste alot of paper? Thanks for any Information or help. Keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| How to write a macro to get the system time in excel 97 | Excel Discussion (Misc queries) | |||
| how to write macro after autofilter is applied | Excel Worksheet Functions | |||
| Date macro | Excel Discussion (Misc queries) | |||
| How do I write a macro for... | Excel Discussion (Misc queries) | |||
Linear Mode
