Excel waddooo endooo???

[!!~SpearHead~!!]

yaluwane,

mata excel wada wagayak thiyenawa office eke. menna me dewal karanne kohomdada?

1)
"H" to "K" thiyena onama cell ekak update kaloth, ae update karapu "Date" eka, "time" eka saha "user name" (windows user nam hondai) eka pick karanne kohomada.
"H-K" thiyena cell row ekak update kaloth me info tika pick karanna one column "A", "M" saha "N" wala cells wala adala cell ekata kelin.

2) Column H-K thiyena cells wala "16" digits whitharak danna limit karanne kohomada. Limit karala vlookup karanna one enter karana no. eka list wela thiyenwada kiyala base file eke.
Eg: 1234567891234567 enter karama eka thiyenwda kiyala anith file eke. nathnam error message ekak denna one.

 

[GAC]

yaluwane,

mata excel wada wagayak thiyenawa office eke. menna me dewal karanne kohomdada?

1)
"H" to "K" thiyena onama cell ekak update kaloth, ae update karapu "Date" eka, "time" eka saha "user name" (windows user nam hondai) eka pick karanne kohomada.
"H-K" thiyena cell row ekak update kaloth me info tika pick karanna one column "A", "M" saha "N" wala cells wala adala cell ekata kelin.

2) Column H-K thiyena cells wala "16" digits whitharak danna limit karanne kohomada. Limit karala vlookup karanna one enter karana no. eka list wela thiyenwada kiyala base file eke.
Eg: 1234567891234567 enter karama eka thiyenwda kiyala anith file eke. nathnam error message ekak denna one.

okata lesima wade program ekak liyala data base ekak use karana eka..

 

[!!~SpearHead~!!]

okata lesima wade program ekak liyala data base ekak use karana eka..

ewa dannaha kollo.

VBA code ekak mata hadala dunnoth puluwan copy paste kara ganna excel eke.

 

[BLACKLIST_MEMBER]

okata lesima wade program ekak liyala data base ekak use karana eka..

hikz uuta programming puluwannam uu excel kora kora indie da

excel karana ekek ea gena ahuwama lesima wade program ekak hadana ekalu,

 

[BLACKLIST_MEMBER]

http://stackoverflow.com/questions/6934169/how-to-show-current-user-name-in-a-cell

http://stackoverflow.com/questions/...-user-name-in-excel-spread-sheet-using-macros

http://www.mrexcel.com/forum/excel-questions/2252-get-windows-user-name.html
me tika modify karala hadaganna puluwanda balapan machan?

 

[!!~SpearHead~!!]

http://stackoverflow.com/questions/6934169/how-to-show-current-user-name-in-a-cell

http://stackoverflow.com/questions/...-user-name-in-excel-spread-sheet-using-macros

http://www.mrexcel.com/forum/excel-questions/2252-get-windows-user-name.html
me tika modify karala hadaganna puluwanda balapan machan?

mewa baluwa macho. mata VBA gana danumak naha.

 

[Mindada hee sara..]

yaluwane,

mata excel wada wagayak thiyenawa office eke. menna me dewal karanne kohomdada?

1)
"H" to "K" thiyena onama cell ekak update kaloth, ae update karapu "Date" eka, "time" eka saha "user name" (windows user nam hondai) eka pick karanne kohomada.
"H-K" thiyena cell row ekak update kaloth me info tika pick karanna one column "A", "M" saha "N" wala cells wala adala cell ekata kelin.

2) Column H-K thiyena cells wala "16" digits whitharak danna limit karanne kohomada. Limit karala vlookup karanna one enter karana no. eka list wela thiyenwada kiyala base file eke.
Eg: 1234567891234567 enter karama eka thiyenwda kiyala anith file eke. nathnam error message ekak denna one.

මට ඔයා කියලා තියෙන එක හරියට තේරුනානම් මේක (2) Data Validation එකකින් කරන්න පුළුවන්.

Office 2007

Select H - K -> Go to "Data" main tab -> Select Data Validation - Select Data Validation from drop list -> On Settings tab of data validation dialog box, Select option "List" from Allow drop list ->Update reference of your Base to the Source field -> Go to "Error Alert" tab of data validation dialog box -> Update your error message - Save (OK)

 

[amaris NO 1]

මට ඔයා කියලා තියෙන එක හරියට තේරුනානම් මේක (2) Data Validation එකකින් කරන්න පුළුවන්.

Office 2007

Select H - K -> Go to "Data" main tab -> Select Data Validation - Select Data Validation from drop list -> On Settings tab of data validation dialog box, Select option "List" from Allow drop list ->Update reference of your Base to the Source field -> Go to "Error Alert" tab of data validation dialog box -> Update your error message - Save (OK)

 

[!!~SpearHead~!!]

මට ඔයා කියලා තියෙන එක හරියට තේරුනානම් මේක (2) Data Validation එකකින් කරන්න පුළුවන්.

Office 2007

Select H - K -> Go to "Data" main tab -> Select Data Validation - Select Data Validation from drop list -> On Settings tab of data validation dialog box, Select option "List" from Allow drop list ->Update reference of your Base to the Source field -> Go to "Error Alert" tab of data validation dialog box -> Update your error message - Save (OK)

Machan pick wenne nahane

 

[*danushka*]

machan puluwannam umba sample excel sheet ekak upload karala danna ethakota eka balala oyage wade therum ganna lasi.

 

[D@sun]

bump!

 

[!!~SpearHead~!!]

machan puluwannam umba sample excel sheet ekak upload karala danna ethakota eka balala oyage wade therum ganna lasi.

Onna macho..


View attachment Sample.zip

 

[Robin*Hood]

oka machan excel walata wada access walin karana eka thamai practical. hariyatama wade karaganna kauru hari waddek udaw karai ubata ​

 

[!!~SpearHead~!!]

oka machan excel walata wada access walin karana eka thamai practical. hariyatama wade karaganna kauru hari waddek udaw karai ubata ​

thanks macho.

 

[Wild-EYE]

Bump