Is this so you can print separate billing statements?

If yes, you may want too look at Debra Dalgleish's site:
http://www.contextures.com/xlForm03.html

If you're trying to build a data entry form:
http://www.contextures.com/xlForm02.html



wrote:

Hi all,

I'm a complete noobie at Excel VBA,,,

My problem is...

I have a spreadsheet and on page 1, named "MAIN"..

I want to be able to select a row, and have the cells copied to another
sheet

Copy the data from cells C4, D4, E4, F4, K4, L4 and P4..(from sheet
MAIN)

into sheet Billing Statement..

B9, C9, B10, B14, A17, D17, F10 Respectively...and the Cell numbers
increment by one as each row goes down...

The sheet for the data to be copied to is called Billing Statement...

Any help on this would be fantastic,,,been trying to figure it out for
ages..

I have about 100 lines, and would like to make one button that affects
which ever row is selected and copys the data from the above mentioned
cells to the ones mentioned afterwards..

Obvisously I'd rather not manually record over 100 different buttons,

Feel free to post here or mail me directly if you need more
information.

Thanks!

--

Dave Peterson