Excel Formula - Copy Paste Formula - increment by only 1

[ultramel123]

I have a sheet "invoice template" which contains 6 rows per 'invoice'. Each invoice pulls the reference and the container number from the second...

[JacquesBlom]

We are in a predicament where we ended our contact with the accountancy firm, on good note, even paying them ALL that was required as per the contract....

[ultramel123]

Hi

the sales master report works for what i need (sales per customer for the last 2 years), but it shows the totals of sales per inventory...

[Odette4]

I have a Pastel company backup and need to export it to excel.
The company closed, but all data is needed.
Can I export it without Pastel...

[ultramel123]

Good Morning

I wonder if there is perhaps a solution out there for our requirements please, if anyone possibly has any suggestions? If...

[Helizelb]

Good day,

I am struggling to enter a formula into Excel.

We do our employees time sheets on Excel. I am trying to automate...

[ultramel1987]

Good Morning

I currently receive the information on what to invoice our customers in excel format. It is a line by line spreadsheet detailing...

[Helizelb]

Good day everybody,

I need a formula on how to calculate leave days due in Excel.

In the first year of service the employee...

[michellepace]

Hi there,

Does anyone know if it possible to export to Excel as a CSV file? I'd like to use this CSV file to create Excel pivot tables....

[ultramel1987]

HI

I have recently installed Microsoft office 365, and since then I cannot export any Pastel reports to Excel...
It says check that...

[nikkidv]

I have Pastel Partner 2009 and would like to know if I can export Debtors/Creditors Journals to excel so I can have someone else fill them in daily. And...

[jopisan]

I have a customer who needs to import quite extensive Excel generated Quotations into Pastel Partner 14.

One department creates a Excel...

[ultramel123]

Good Day

I have a situation where I need to invoice a particular client per "item" (ie one invoice per item) - which is approximately...

[Mynhardt]

I thought you guys might find this useful.

Over the past two years I have gradually created a list of functions to easy general formatting...

[Laurence Lombard]

Over the years I have developed some Excel based applications for my business (in this case a farm) which I think may be useful to others.
Amongst...