Hi. Our office pay slip contains info every month through a mailmerge from Excel. I would like to add a "To Date" column after the "This Month" column in the pay slip but the source is in another sheet but the same workbook. Is there a way do this?
My laptop cannot connect to with the cp hotspot so I cannot attach a file, sorry.


Thank you.

Can you add another worksheet to the workbook that contains the information from both sheets? Can you create another workbook that contains the information from both sheets in the other workbook? If neither, what is the relationship between 'This Month' and 'To Date'?

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

The workbook contains the payrolls per month. Jan sheet is January payroll, Feb sheet is February payroll and so on. There is a Consol sheet that consolidates (sums) all the monthly payrolls. From the monthly payroll, we prepare individual pay slip (Word) for each employee using mail merge. The This Month is the basic salary, allowances and deductions for the payroll month, say June. The To Date should be the total salaries, allowances and
Deductions of the employee from January to June. The source of the To Date is the Consol sheet

I am attaching sample pay slip and payroll.

Attached Files

	PAYROLL.xlsx (156.2 KB, 9 views)
	PAY SLIP.doc (117.5 KB, 9 views)