Search by columns or by rows
 

I receive a series of 8 spreadsheets that I clean-up and pretty-up to
go out to the counties. I've been checking the column headers in the
raw data sheets by hand to see if they have the right columns before I
procede to process them. My next macro will do this for me.

I have a choice, and am not sure if it matters or not, but what are, if
any, the advantages of having the spreadsheet names across row 1 and
the column headers for that spreadsheet listed down the column, or
having the spreadsheet names down Col A and the column headers across
the row? I'm not concerned about speed, there are only 8 sheets and the
biggest ones have 21 rows, so speed won't be a factor. Is there any
difference in doing this by rows vs. by columns? In general, are there
advantages or disadvantages to doing things in Excel by row vs. by
column?

Thanks!

Search by columns or by rows
 

There are a lot more rows than there are columns so if your spreadsheet is
going to expand it is far better to have it expand down than it if to have it
expand across.

The other advantage to rows is that they are numbers which makes them a bit
easier to deal with in code. I can do the offsetting in my head (If I am on
row 5 and I offest 10 rows I will be on row 15. If I am in column E and I
offset 10 columns I an in column ???)

In terms of speed there is no advantage either way.
--
HTH...

Jim Thomlinson


"davegb" wrote:

I receive a series of 8 spreadsheets that I clean-up and pretty-up to
go out to the counties. I've been checking the column headers in the
raw data sheets by hand to see if they have the right columns before I
procede to process them. My next macro will do this for me.

I have a choice, and am not sure if it matters or not, but what are, if
any, the advantages of having the spreadsheet names across row 1 and
the column headers for that spreadsheet listed down the column, or
having the spreadsheet names down Col A and the column headers across
the row? I'm not concerned about speed, there are only 8 sheets and the
biggest ones have 21 rows, so speed won't be a factor. Is there any
difference in doing this by rows vs. by columns? In general, are there
advantages or disadvantages to doing things in Excel by row vs. by
column?

Thanks!

Search by columns or by rows
 

Good points! Hadn't thought of the offsetting in my head. Thanks, Jim.

Jim Thomlinson wrote:
There are a lot more rows than there are columns so if your spreadsheet is
going to expand it is far better to have it expand down than it if to have it
expand across.

The other advantage to rows is that they are numbers which makes them a bit
easier to deal with in code. I can do the offsetting in my head (If I am on
row 5 and I offest 10 rows I will be on row 15. If I am in column E and I
offset 10 columns I an in column ???)

In terms of speed there is no advantage either way.
--
HTH...

Jim Thomlinson


"davegb" wrote:

I receive a series of 8 spreadsheets that I clean-up and pretty-up to
go out to the counties. I've been checking the column headers in the
raw data sheets by hand to see if they have the right columns before I
procede to process them. My next macro will do this for me.

I have a choice, and am not sure if it matters or not, but what are, if
any, the advantages of having the spreadsheet names across row 1 and
the column headers for that spreadsheet listed down the column, or
having the spreadsheet names down Col A and the column headers across
the row? I'm not concerned about speed, there are only 8 sheets and the
biggest ones have 21 rows, so speed won't be a factor. Is there any
difference in doing this by rows vs. by columns? In general, are there
advantages or disadvantages to doing things in Excel by row vs. by
column?

Thanks!