Hi,
I have a large spreadsheet with climate data by day. I am re formatting the spreadsheet so that the stations are columns and all the dates from 1884 to 2012 are rows. There are some missing dates and I would like to insert black rows for the missing dates for each station. I have been filtering the data to isolate each station.
Any ideas?
Thanks!
try the following macro:
Please Login or Register to view this content.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
It's hard to see exactly what you want without a sample spreadsheet, but maybe if you run this code on some test data to see if it's on the right track. This assumes no column header. May give error if you do have a column header, but very easily remedied.Please Login or Register to view this content.
Last edited by kalak; 06-26-2013 at 03:47 AM.
hmm ...
minor problem in my code posted above.
please substitute this one insteadPlease Login or Register to view this content.
Thanks,
I get an error at the No_Row_To_Add line
SAMPLE_VT_NCDC .xlsx
Attached is some sample data.
Thanks for the help
Where are the dates? Which column?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks