상가빌딩 관리사무소 세부내역 대장입니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

관리비청구 프로그램을 쓰고있는데ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">. 너무 복잡하고 일이 많아서ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">. 엑셀폼으로 개발하고싶습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

본내용이 보편적 상가빌딩의 항목이며ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 내용을 토대로 호실별ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 또는 상가ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">(그룹ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">)별로 고지서 출력까지 연동하고 싶습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

고지서에서 전체 전기료ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 수도세ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 보험비가 나오며 상가별로 사용내역이 표기되면 좋을 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

회사로고도 삽입되면 좋구요ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

본고지서는 납기후금액을 나타낼 수 있는 란도 있음 좋을 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.(이자율ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">5%)

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

추가로 본고지서는 문자이미지 파일 및 출력 청구가 되며ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 대표계좌 또는 가상계좌번호란도 들어가야 할 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림"> 

자동이체 ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">cmsng=EN-US style="mso-fareast-font-family: 함초롬바탕"> 신청란과 전월 수납확인서도 삽입되면 좋을 것 같구ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">, 자체적으로 수납확인을 체크할 수 있는 란도 있어서 통합월별 종합납부현황페이도 있으면 좋을 것 같습니다ng=EN-US style="mso-fareast-font-family: 굴림"> ng=EN-US style="FONT-FAMILY: 굴림; LETTER-SPACING: 0pt; mso-fareast-font-family: 굴림; mso-font-width: 100%; mso-text-raise: 0pt; mso-ascii-font-family: 굴림">.

1. 이용중인 엑셀 버전 : (ex) 엑셀2019


2. 엑셀케어이용권 체크 :


 □ 프리미엄 30(30일)


3. 프로그램명과 오류내용

고객님 안녕하세요 
ng>업무자동화 엑셀쿠키전문가ng> 입니다. 
olor="#414042" face="나눔고딕, NanumGothic, sans-serif">단가항목을 추가등록, 불러오기, 수정, 새로작성 등을 적용할 경우

VBA코드를 수정 작업이 진행되며, 저장DB 추가 작업이 진행됩니다.



또한, 금액란의 수식이 적용된 수식이

어떤 란은 C/Weight와 곱하도록 되어 있는데

어떤 란은 그냥 단가만 연동되어 있습니다.



해당 부분에 입력한 수식도 유지 및 저장되어야 하는 부분인가요?



답변을 주시면 구성을 확인 후 비용 및 기간을 산정하여 답변을 드리겠습니다.
 
또 다른 문의사항이 있으시면 언제든지 문의 바랍니다.  
감사합니다. 
업무 자동화 파트너 쿠키 드림 
 
 
 
-> 네,  H열 단가 부분 수식도 유지 및 저장 되도록 수정 부탁드립니다.
 
olor="#414042" face="나눔고딕, NanumGothic, sans-serif">되도록 10/2(수)까지 수정 가능한지 확인 부탁드리고, 비용도 확인 부탁드립니다.
olor="#414042" face="나눔고딕, NanumGothic, sans-serif">
감사합니다.