automatic update of data in other spreadsheet

[anuj_sethi1043]

plz help me out

i want to automatically update data from one spreadsheet to ther one
i am novice to vb programming


here are two file plzzz help me out --sheet 1--sheet(data of sheet one to be copied into)
and is there any way that the data copied also gets saved the in that spreadsheet as next time data in sheet 1 is updated!!


thnxx

[JBeaucaire]

LOL...you posted two empty workbooks. That's pretty funny...

Ok, instead of dumbing it down, post up an ACTUAL workbook or two showing us examples of what you have in mind.

In the meantime, if you're talking about just simple cross-referencing...in 2.xls put this formula in Sheet1 cell A1:

=[1.xls]Sheet1!A1

Then copy that cell down and over as much as you want. This sheet will now show whatever is on sheet1 of 1.xls.

[anuj_sethi1043]

hey here r the sheets
I want to copy orde taken column(d) to get automatically
copied to another workbook … so that history of orders can
be maintained and is that posible to save the copied data to
get saved after few columns when I add new data in this sheet


thnxx

[JBeaucaire]

So, you want to press a button or something and all the data in column D goes over to the "copied data.xls" spreadsheet into the next empty column, starting at D? And then the date is inserted in row 2?

[anuj_sethi1043]

yes if that is possible it would be gr88

[JBeaucaire]

The main sheet has a button, just click on it to run the ARCHIVE DATA macro.

The macro will check to see if "Copied Data.xls" is open or not, it will open it if necessary. It will then paste the data into that sheet in the next open column and insert a date at the top of the column.

Please Login or Register  to view this content.

[anuj_sethi1043]

thnx man it really hlpd me if i wanna change few things and add few things i will pm u
thnkuuuuuuuuu very very much to help me out
man
u r d best
thnxx again

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

[anuj_sethi1043]

hey man there are three files

like u did in first file nirulas one a button to copy data

can u place two buttons on file

and i want the d row to be copied to next file copied one after leaving 2 columns
ex d copied to other file in (column 6 ,nxt time to get pasted in column 9)

in nirulas file only at end the row 138 cells (b,c,d,e,f,G,h) to be copied on click of a button to another file called fill rate with date on top

plzzz help me out its urgent!
thnxx
anujj

[JBeaucaire]

can u place two buttons on file

Yes, but you don't indicate what this second button does...

and i want the D row to be copied to next file copied one after leaving 2 columns
ex D copied to other file in (column 6 ,nxt time to get pasted in column 9)

On the COPIED DATA.XLS sheet, change the formula in B12 to this to get that behavior:
=MATCH(LOOKUP(9.99999999999999E+307,2:2),2:2,0)+3

in nirulas file only at end the row 138 cells (b,c,d,e,f,G,h) to be copied on click of a button to another file called fill rate with date on top

Ok, here's the macro:

Please Login or Register  to view this content.

Add that to your sheet and add a Forms Button to attach it to.

[anuj_sethi1043]

thnx a lot man
u saved me
thnx again

[punna111]

file opening is necessary?
Without opening file can i transfer data to that "copied data" workbook

please help me....

[arlu1201]

punna111,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

[punna111]

I am so sorry for inter-fearing in another member thread.

actually i didn't read forum rules.

prb