thanks for the quick replies.
@bobhc I didn't explain myself properly; actually I'd like my foreign colleagues would fill a data entry sheet including one row/one figure for every managing account of their companies
example
- sales 1500 usd (cell A2:1500)
- Intercompany sales 100 usd (cell...
Hi everyone.
I'm wondering if were possible to enter a multiple detail in one single Excel cell through any Excel or vba tips.
For example, I want my company xy enters its intercompany balances to other companies in a single cell that reflects Intercompany sales.
- Intercompany sales usd 100...
Hi Narayan!
Sorry for coming with a new request on the same matter but I use excel 2003 at work and the formula in the sheet doesn't work there (probably it was not included in former MS office excel versions).
Thanks for the tips.
Daniele
Hi Narayan, I checked and it perfectly works. Now I want try by myself if is possible to obtain the same output changing manually "payments days" in column B. For example, in B4 cell choosing 90 days instead of 0 days I'd like cash flow were automatically updated. Do you any formula to advice...
Hi Narayan!!
Please download this version in which I reported an example of what I'm looking for.
http://wikisend.com/download/142706/CUSTOMERS_CF_2.0.xls
The column B include customer invoices aging days- For example in January I'm going to issue 150$ invoice and payment term is zero days...
Hi Narayan, thanks for the reply.
I think this one should work.
https://skydrive.live.com/#!/edit.aspx?cid=CD31EC8AC9CB8D4F&resid=CD31EC8AC9CB8D4F%21146&app=Excel
or
https://skydrive.live.com/#!/edit.aspx?cid=CD31EC8AC9CB8D4F&resid=CD31EC8AC9CB8D4F%21151&app=Excel
Hi!! First at all my best congratulations for the brilliant and user friendly work you're doing here. I'm currently working in accounting and financial area of a big italian group. Well, it seems they dont want invest further money on developing of accounting and mngmt softwares I'm using. So, I...
Hi everyone!!!
Im Daniele from Italy, just discovered this superb website that probably will help me a lot in the next future. In addition think I'm going to spend many hours here cause it should solve a lot of financial matters that currently I'm facing and board's reporting as well.
regards!