How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask NewITZone Your Own Question
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I Have excel sheet accts, so i need a small little

Customer Question

I Have excel sheet for my accts , so i need a small little programming on it
Submitted: 10 months ago.
Category: Microsoft Office
Expert:  Jason Jones replied 10 months ago.

Hello,

I am the person that will be helping you today.

How may I help you today?

I will be standing by, looking forward to your response.

Thank you,
Jason

Customer: replied 10 months ago.
Relist: Other.
seems he is microsoft tecnician not programming with sheet
Expert:  Jason Jones replied 10 months ago.

How may I help you today?

Customer: replied 10 months ago.

http://wikisend.com/download/533722/NEW ACCTS.xlsx

this is my accounting file

as u see there is sheet 7

i want when i enter data in sheet 7 with date & transfer number

i want programming or function should work with transfer number to get the output result into sheet SANA & MAIN SHEET

AS i have entered manually in sheet sana & main for transfer 2001 amount is 5,000,000

so when i entere in sheet 7 date transfer no 2001 and amount IN & out as u see for 2001 ( IN ) IS MAIN AND ( OUT) IS SANA

SO I want in sheet MAIN SHOULD GET FILLED DATA FOR 2001 WITH IN COLUM OF SAME AMOUNT WHICH IS ENTERED IN SHEET 7

AND SAME DATA SHOULD BE FILLED AS ( OUT ) COLUMN IN MAIN SHEET FOR SAME TRANSFER NO 2001

I HOPE YOU HAVE UNDERSTOOD

Expert:  Jason Jones replied 10 months ago.

I have run out of ideas.

For this reason, I am opting out of the question and allowing another expert the chance to help.

The next expert will see all that is on this page, so there will be no need to repeat anything.

When another expert picks this up, you will be notified by email.

Thank you for your patience.

- Jason

Customer: replied 10 months ago.
Relist: Other.
SEEMS not expert saying no idea
Expert:  Carl L replied 10 months ago.

Hi, I'm Carl. It looks like Jason has opted out but I will continue where he left off. The way you described how you want the Excel Sheet to function is a bit confusing so we will need to break it down one section at a time. Can you resend the Excel File since the first one you sent has expired?

Related Microsoft Office Questions