Macro code required: if cell = S*(wildcard) then copy from one cell to another

Hi all.

I've only just started learning about macros so I'm not overly sure on the language used at this stage; you have to start somewhere right?! Anyway I have an exported document that spits out a info like the following

A B C D

Site : S01


Point #
1 1
2 2
3 3

Total 6


What I need my macro to do is move the data from one cell - "S01" to the cell before the range of point numbers (ie the 1, 2 and 3 - the number of points varies as well).
Speed of the marco isn't a factor and I have some row deletes which will fix over run so I'm thinking I set the copy for a range of the maximum points in any site possible then delete the unused afterwards. Crude I know but it will suffice for what I need.
Also, as an extension to this question, the site name varies from s1 to s01 to s403 etc so is it possible to have code that is able to register the # after the S using a wildcard or something? Unsure on this point.

Any help on this would be great!

Cheers

Linc

can you attach a sample file for testing with initial data and desired result?

Please Login or Register  to view this content.