In Progress

Excel Problem

In excel I have a folder and within that folder I have 3 folders called A1, A2 and A3.

In each of these three folders are more folders, each one being the name of a client. Within these folders will either be spreadsheets or more folders with spreadsheets within these folders. Each folder once you have drilled down will have a spreadsheet with the word ledger in the title somewhere. Each client folder could have more than one sheet in with the word ledger in the name and we need data from each of them. There will be other spreadsheets that don't have the word ledger in them and we do not need to retrieve data from them.

Each sheet that has ledger in the title is an accounts ledger.

In A1 the majority of ledger sheets will only have 1 transaction on it but it could have more or non at all. In A2 the ledger should always have a balance. In A3 I would expect all the ledgers to have had at least 2 entries but now have a zero balance.

Each sheet with the word ledger in the title is the same template and contains the client info and accounts transactions. The client info on each sheet can be found in the same cells on each sheet. The accounts transactions start on the same row on each sheet but there could be a number of transaction rows. From 0 to maybe 30, possibly more.

The columns for the transactions are the same on each sheet starting in the same columns. There are 8 columns. date, type of entry and then debit and credit for one account (office) then a running total and then debit and credit for a second account (client) and the running total. There is a formula in both running totals columns using the information input in to the credit and debit columns. When we add transactions to the ledger we copy the last row and paste onto the next so it copies the formula and then type over the entries with the new data we need to enter.

There may be text at the bottom of the ledger which is irrelevant to the data I need.

I need to run a report that tells me the client name, code and account balance for client and office on each ledger for a specific date. This figure could be in a different row cell reference on each ledger sheet depending on how many entries have been recorded on each sheet but will be in the same columns. This could be in the middle of the list of transactions and there could be a number of transactions on that date so it would need to choose the last transaction with that date. The figure could be positive or negative.

It would be helpful if I can run the report on each folder (A1, A2, A3) independently of each other.

Skills: Excel

See more: sheets add, me excel, how to run an office, excel balance sheet template, accounts office reference number, accounts office reference, 1. problem, 1 problem, excel spreadsheet formula, excel sheet formula, A3, a1, report from excel, problem with name, Ledger , Excel report, excel formula, copy excel, copy data from word to excel, balance sheets, transaction report, excel formula spreadsheet spreadsheet, excel contains, excel specific, word add date

About the Employer:
( 1 review ) Harrogate, United Kingdom

Project ID: #1104134

Awarded to:

sammw21

Hi.. I can do this.. I will also send a PM.

£20 GBP in 1 day
(2 Reviews)
3.5

34 freelancers are bidding on average £77 for this job

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

£200 GBP in 7 days
(65 Reviews)
6.4
gshiels

Please see PM

£50 GBP in 1 day
(11 Reviews)
5.1
stacross

we'd like to bid on your "Excel Problem" project. Refer to PM.

£80 GBP in 0 days
(16 Reviews)
3.9
muthumuni

………..#####... “KINDLY FOLLOW MY MASSAGE & FEEL REAL DIFFERENT HERE” ...##### ……….. ...

£45 GBP in 3 days
(7 Reviews)
3.8
jadinv

Hi dullusk, Please see PM for important information. Thanks, Jeff

£150 GBP in 5 days
(1 Review)
2.8
akshayfastin

Please check my PM for details.

£75 GBP in 1 day
(3 Reviews)
2.6
SilviaT

Let me try.

£250 GBP in 7 days
(5 Reviews)
2.3
PG89

Hi, Please check PMB.

£45 GBP in 1 day
(2 Reviews)
1.6
shoaibsial

Hi sir! I really interested in this job.

£75 GBP in 7 days
(0 Reviews)
0.0
triumphchem

we have good knowledge of this type of assignments so we are confident that we will be able to do the job to your satisfaction.

£68 GBP in 8 days
(0 Reviews)
0.0
ALIISFAND

ready to do work

£20 GBP in 1 day
(0 Reviews)
0.0
vioricajutaru

Hi, I am interested about your project, I am a very good typer and very hard working person and I will try fully to complete your work.

£70 GBP in 5 days
(0 Reviews)
0.0
ptseeker

Hi, this is similar to my regular job. Can try on me. Thank

£20 GBP in 1 day
(0 Reviews)
0.0
specian

I mostly help on free tech support forums to help create customized workbooks with vba. If you are using Mac software it will be a little trickier, but still quite possible.

£20 GBP in 2 days
(0 Reviews)
0.0
Adisehgal

Please Check PM

£30 GBP in 2 days
(0 Reviews)
0.0
nvtd

I am interested in getting this job and get completed asap

£250 GBP in 7 days
(0 Reviews)
0.0
AjeetPrasad

Working with an United State Payroll Company. Total Experience in VBA is more then 5 Years. Made many manual processes to Automated. Example:- ð With in the Company Macro for General Ledger to clear and read More

£100 GBP in 7 days
(0 Reviews)
0.0
rcs49781

Have handled similar jobs

£20 GBP in 5 days
(0 Reviews)
0.0
SOUNDAYAN

I had 12 years experience is computer job typing work and data entry work. I am also disabled person. Please give business opportunity.

£350 GBP in 20 days
(0 Reviews)
0.0
jjjzala1983

i can enter data in excel with provided supporting

£21 GBP in 3 days
(0 Reviews)
0.0