Inserting specific data into moving cells

  • Thread starter Thread starter Max Velocity
  • Start date Start date
M

Max Velocity

Hi,

Can someone give any ideas on the best way to insert data, sometime
just text and sometimes formulas in certain cells in a worksheet usin
a macro. The tricky bit of this is that these cells although always i
the same column are never in the same row because of the data bein
imported from a dynamic database.

The good part of this problem is that in the spreadsheet there i
always a reference for where and what I want to insert.

I have attached a spreadsheet at least I think I have) with a littl
example of what im talking about if you care to have a little look.


Cheers,

Ma

+----------------------------------------------------------------
| Attachment filename: example of data.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=368256
+----------------------------------------------------------------
 
Sorry Max, no attachments please.

Post back with details of where these references are, what
format they are in and the potential sizes of your data.

Pete.
 
Well it goes a little like this.

in the spreadsheet i have six categories of data. These will normall
take up between 20 and 100 rows each. Between each each category o
data there are 4 blank rows.

My macro already sorts the categories of data by using column D, wher
I have an IF function sorting data into number categories, i.e
1,2,3,4,5 & 6. Therefore each row of data is categorised with one o
these numbers.

I would like to insert a title for each category of data in column
but I don't know what row it will be in. 1,2,3,4,5,6 = a text name e.g
1 =North America.

I Would then like to make a Totals cell with of all the numerical dat
in a category. These numbers are always in column C but once again
don't know which row it might end up at.

Cheers,

Ma
 
Back
Top