Excel and VB Script help

[etzina]

---

hi guys, gipa himo mi ug form (in an excel worksheet) and we based our vb script from this site: Excel - adding data to a list (part two)

what it basically does is that we have sheet1 as the form, and sheet2 as the table of data that has been typed on sheet 1.

we have already accomplished this, any info typed in sheet 1, when the macro is run, mu append sa sheet 2 list ang data.

now here's the problem... If we delete a row or any info sa sheet 2, the counter amo gisetup dili mu change... so example... on sheet 2, rows 1 til 5 have info already... then we delete info on row 4.. if we type in on sheet 1 form, and run the macro, the data is then appended on row 6, not on row 4...

naa mo script na makatabang ug check na sheet2 table row if empty diha sya mu append sa data? galibog ko coz dugay2x nako la nakaatubang ug vbscript gud...

ty .. i hope na explain ra nako unsa ako gi mean

[etzina]

nobody knows ?

[nirdle_phogi]

https://www.istorya.net/forums/programming/ basin naa makatabang mga programmers ngadto..

[etzina]

thanks for the info! na miss ngali nako kana nga subforum la ko kabasa dah... ty ty..

mods plz close this thread, ill make one sa correct subforum ty