If all addresses are of same no. of fields, you can make data as you want using indirect function and series fill.
1. First copy data to the column A
2. In cell B1 enter cell reference of first name data that is A1 and in cell B2 enter cell reference of second name data that is A8
3. Enter the...
If your purpose to display data only, you can save as excel file in a web page which only display data not formula. if open this web page in Internet Explorer there will be an option to edit data (not formula) in excel.
We are using accpac. Our fiscal year periods start from Jan and end in Dec. We are going to change periods from August to July. How to change these in ACCPAC? Do I need to create a new company or I can do in the same company?
I have transfered an order into invoice then by mistakely I deleted the invoice. I have to recreate an invoice but problem is quantity available on line item does not change even after I deleted the invoice ( may be because of historical order which I have transfered). How do I change quantity...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.