PDA

View Full Version : Autofilling



faboboren
11-22-2007, 12:30 PM
Hi Experts,

I have arrays in 45 sheets and 11 workbooks. Arrays are row variable, but they are fixed from A:M.
Rows are orderd by C column from # 1 to N, however after I applied a macro some of rows are deleted.
I am looking for a code to autofill C column from # 1 to the leftover rows.

Example:


original after delete after autofill
1 1 1
2 3 2
3 5 3
4
5
6

Thanks

mdmackillop
11-23-2007, 06:49 AM
Can you post a small sample after deletion. Use Manage Attachments in the Go Advanced section.

faboboren
11-23-2007, 08:12 AM
Hi MD,

I have attached the excel example I was reffering to. Like I said, I have in every file 45 sheets (like those 5). They have different amount of rows (usually they do not go more than 200 rows). Then I have 11 woorkbooks like this. I want to do the autofill from 1 to N, because after I have applied my delete macro and missing some rows, so I need to re-sort by C column.

Thanks