Käynnissä

Automating Bill Print Format in Excel

Please quote only if you know "EXCEL MACRO"

I have an excel sheet with column names as shown below

Bill no

Bill date

Customer name

Item name

Quantity

Item amount

I require someone to do the following

* Read bill no from Excel sheet1

* Gather items corresponding to a particular bill no

* write the gathered data into "sale bill" format into sheet2 (sale bill format will be provided once the project is assigned)

* every page in sheet2 should contain only one bill (page meaning, print preview page. Not sheet)

* and read the next bill no from sheet1 and follow the above steps

i may need to add/delete columns in the future so the code should be flexible to add/delete column

I may tweak the requirement during the course of the project to attain the desired result but the main idea of the project is to,

"Read the data from sheet 1 and write the same data into Sheet 2 in a bill print format"

Sample data may contain few rows but the actual data may contain 1000's of rows. so looping is necessary.

Taidot: Excel

Näytä lisää: bill print format, print bill format excel, excel bill print, format bill excel, excel print bill, excel macro bill print, print bill excel format, data bill format excel, need someone to do a excel project, meaning of quote, attain, bill print excel sheet, customer data in excel, name format, format excel, bill, bill of quantity, automating, excel macro add, excel 2013 macro, excel project idea, automating excel, add print, excel quote name, excel print sheet

Tietoa työnantajasta:
( 22 arvostelua ) Nellore, India

Projektin tunnus: #4265731

Myönnetty käyttäjälle:

vikashgadia

LETS COMPLETE IT NOW WE HAVE MORE THAN 13 YEARS EXPERIENCE IN VBA

40 $ USD 1 päivässä
(13 arvostelua)
3.5

12 freelanceria on tarjonnut keskimäärin 39 $ tähän työhön

nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet co Lisää

50 $ USD 3 päivässä
(39 arvostelua)
5.4
mrbrave

HI...I have better solution for [url removed, login to view] message box for demo and details.

40 $ USD 1 päivässä
(64 arvostelua)
5.3
jaylancer43

Ready to start right now...!!

50 $ USD 2 päivässä
(6 arvostelua)
2.9
epdailo

I think I can get you what you need.

30 $ USD 7 päivässä
(2 arvostelua)
2.2
vedranvivoda

Hi. Project description is clear, I can start working as you provide me with sample sheet. Check pm for sample of excel book similar to one that you need

40 $ USD 1 päivässä
(1 arvostelu)
1.6
cssoftware2012

Hi,I have already done this type of work in excel.I can do this work efficiently and at proper time. Thank You

35 $ USD 7 päivässä
(0 arvostelua)
0.0
dipakdhola09

hi Apply For this Project. and i have good knowledge in Excel.

45 $ USD 3 päivässä
(0 arvostelua)
0.0
bhojanapriyulu

Hello, I have read description carefully.I understood your project concern.I am very much interested for this [url removed, login to view] to start immediately. I will follow all [url removed, login to view] you have any question related to budge Lisää

40 $ USD 5 päivässä
(0 arvostelua)
0.0
mrsumairarilwan

i can do my work best.

30 $ USD 50 päivässä
(0 arvostelua)
0.0
woycieszek

I work with SAS tools and MS Excel. I have a lot of free time and I simply like programming.

35 $ USD 2 päivässä
(0 arvostelua)
0.0
onlineupdatebd

I am really serious to work on your project. I will complete your work via myself with very carefully.

30 $ USD 7 päivässä
(0 arvostelua)
0.0