Autofill and Formula problem :)

[chrisguk]

Hi,

For the purpose of this question I have two sheets named "Data" and "Compiled".

Data - This has predetermined headers and the raw data is pasted in only.

Compiled - The first column of this sheet has a formula like so:

=IF(Data!A5=0,"",Data!A5)

The problem is I cannot autofil column A and I dont know how to do it with VBA which would be my idea solution. For example.

Column A1 look at Data!A1 and count how many rows are populated then autofill that value.

Hope that makes sense?

 

[wigi]

Hi

Can't you use an autofilter to filter on column A in the Data tab, filtering on the non-zero values?

 

[chrisguk]

The data tab is already populated with raw data.

The Compiled tab is what I want to autofill down based on the amount of rows populated in the data tab.

Like I said the Compiled tab has the first formula in it. I want it to count how many rows are populated then autofill to that given number.

 

[wigi]

What is the range of cells used on both worksheets?

 

[chrisguk]

Basically range for the Data tab is Column D and the rows are determined by how many rows are populated.

Then the autofill will carry out the autofull in Column A in the Compiled tab.

 

[Michael M]

Duplicate post and response here

http://www.mrexcel.com/forum/showthread.php?t=587000

 

[chrisguk]

Really sorry about that Mike, I thought it would be better to try and word it different.