How to write a macro??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a list from offset data 9
How do I write to a closed work book as a "register" 1
Automatically generating spreadsheet B from spreadsheet A 1
Macro Help 1
Macro to push data to another workbook 0
I am trying to write a macro using If...Then 1
Writing Macros 2
macro to filter 6

Back
Top