Sleeper: Copying data to different worksheet

[djhampton]

Hi guys, this is my first post here, i've been reading several posts and found they are very useful

I've been working to build up a system to help me with the invoice of a small company, i've managed to come up with most of the problems but now that i'm almost done, i found somehitng that haven't been able to solve.

In Spreadsheet A i have a series of data, all the data that goes in the invoice i have to print.

Now the thing is that i need to store all this data into Spreadsheet B, which is where i have to store all the data from all the past invoices, ordered by the invoice number.

Any sugestions?

[Zack Barresse]

Hi there, welcome to VBAX!!


Sure this can be done. Quite easily at that. It would help though if you could upload a zipped sample spreadsheet for us to look at. That way we know what we are dealing with, and you get customized solution(s). See this for uploading help.

[djhampton]

Hey, thnx a lot, tomorrow morning, i'll upload it when i get to work.

[djhampton]

Well, here it is, the zipped one.

I'll Explain what i need. In the spread sheet form, is the form i use for my invoice, and there are several parts which i have to save to a diferent spreadsheet.

What goes under "orden no."; "medio"; "atencion a"; "clave del anuncio"; "cliente"; "r.f.c"; "direccion"; the textbox under "descripcion"; "cantidad"; "fecha de entrega"; "p/u"; "sub-total" and "total".

Have to be saved into another spreadsheet, to make a concentrate of all the invoice i'm made. All this have to be stored orderly according to the number on "order no."

Any suggestion?

[surya prakash]

Hi,
Looks like your data is not in english.

There are several sheets in your workbook and looks like you are extracting data from different sheets.

As your data is not in english, try filling your performa completely, so that we will know, what data you are trying to reference and copy

Prakash

[djhampton]

sure, i'll do that

[djhampton]

Here is the translated version of the file