Home

Excel copy information from another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-759276%22%20slang%3D%22en-US%22%3EExcel%20copy%20information%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-759276%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20a%20spreadsheet%20%22INCOME%22%20-%20customers%20(Rows)%20and%20their%20monthly%20payments%20(columns).%20I%20would%20like%20to%20produce%20a%20statement%20using%20another%20sheet%20%22STATEMENT%22%20which%20picks%20up%20from%20the%20INCOME%20sheet%20the%20customer%20e.g%20A1%20or%20A2%20and%20their%20payments%20e.g%20B2%3AB13%20(Jan%20-%20Dec).%20I%20can%20do%20this%20manually%20for%20each%20customer%20entering%20the%20rows%20and%20columns%20(using%20the%20%3D%20sign%20to%20copy%20the%20information%20from%20the%20INCOME%20sheet%20e.g.%3DINCOMEA1).%20But%20I%20think%2Fhope%20I%20should%20be%20able%20to%20make%20this%20more%20of%20an%20automated%20process%2C%20can%20the%20row%20letter%20be%20picked%20up%20from%20a%20cell%20somewhere%20on%20the%20STATEMENT%20sheet%20so%20that%20It%20will%20automatic%20all%20pick%20up%20whichever%20Customer%20and%20their%20payments%20I%20choose%3F%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMArk%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-759276%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-759390%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20copy%20information%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-759390%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377754%22%20target%3D%22_blank%22%3E%40MarkTemples%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20you%20post%20a%20copy%20of%20your%20workbook%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-762779%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20copy%20information%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-762779%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F106033%22%20target%3D%22_blank%22%3E%40Roger%20Govier%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20getting%20back%20and%20sorry%20for%20delay.%20Here%20is%20a%20copy%20of%20the%20Income%20Sheet%2C%20I'll%20post%20the%20statment%20copies%20separately.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMark%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-762781%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20copy%20information%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-762781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F106033%22%20target%3D%22_blank%22%3E%40Roger%20Govier%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECopy%20of%20Statement%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-762783%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20copy%20information%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-762783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F106033%22%20target%3D%22_blank%22%3E%40Roger%20Govier%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECopy%20of%20Statement%20showing%20formulas%20-%20The%20INCOME%20spreadsheet%20is%20called%20MASTER%20for%20info.%3C%2FP%3E%3CP%3EI'd%20like%20to%20be%20able%20to%20enter%20the%20Row%20number%20somewhere%20on%20the%20STATEMENT%20spreadsheet%208%2C%209%2C%20or%2010%20being%20the%20row%20for%20that%20customer%20-%26nbsp%3B%20and%20produce%20a%20statement%20for%20each%20customer.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eagain%20Thanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMark%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-762959%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20copy%20information%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-762959%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377754%22%20target%3D%22_blank%22%3E%40MarkTemples%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20Mark%3C%2FP%3E%0A%3CP%3ESee%20attached%20workbook.%3C%2FP%3E%0A%3CP%3EI%20haven't%20set%20it%20all%20up%2C%20just%20sufficient%20to%20show%20you%20how%20you%20can%20enter%20the%20Row%20number%20for%20the%20Customer%2C%20and%20the%20Index%20formula%20will%20bring%20you%20back%20all%20the%20relevant%20data%20for%20them%20to%20your%20Statement%20sheet.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20copy%20the%20relevant%20formulae%20to%20your%20workbook%20and%20all%20should%20work%20fine.%3C%2FP%3E%0A%3CP%3EHope%20this%20helps%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-763013%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20copy%20information%20from%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-763013%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F106033%22%20target%3D%22_blank%22%3E%40Roger%20Govier%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHey%2C%20that's%20brilliant%2C%20thank%20you%20very%20much%2C%20just%20what%20I%20was%20hoping%20could%20be%20achieved.%3C%2FP%3E%3CP%3EMark%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
MarkTemples
Occasional Contributor

We have a spreadsheet "INCOME" - customers (Rows) and their monthly payments (columns). I would like to produce a statement using another sheet "STATEMENT" which picks up from the INCOME sheet the customer e.g A1 or A2 and their payments e.g B2:B13 (Jan - Dec). I can do this manually for each customer entering the rows and columns (using the = sign to copy the information from the INCOME sheet e.g.=INCOMEA1). But I think/hope I should be able to make this more of an automated process, can the row letter be picked up from a cell somewhere on the STATEMENT sheet so that It will automatic all pick up whichever Customer and their payments I choose???

 

 

Thanks in advance     

 

MArk 

6 Replies

@MarkTemples 

Can you post a copy of your workbook?

@Roger Govier 

Thanks for getting back and sorry for delay. Here is a copy of the Income Sheet, I'll post the statment copies separately.

 

Mark

@Roger Govier 

 

Copy of Statement showing formulas - The INCOME spreadsheet is called MASTER for info.

I'd like to be able to enter the Row number somewhere on the STATEMENT spreadsheet 8, 9, or 10 being the row for that customer -  and produce a statement for each customer. 

 

again Thanks in advance

 

Mark

@MarkTemples 

Hi Mark

See attached workbook.

I haven't set it all up, just sufficient to show you how you can enter the Row number for the Customer, and the Index formula will bring you back all the relevant data for them to your Statement sheet.

 

You can copy the relevant formulae to your workbook and all should work fine.

Hope this helps

 

@Roger Govier 

 

Hey, that's brilliant, thank you very much, just what I was hoping could be achieved.

Mark

 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies