• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to give rows reference to colums

K

kalpesh39

New Member
hi,

i want to make an excel workbook where columns contains the center name & rows contains the dates, by manual entry.

now i want this entry goes to different Sheets for different collection centers in column date by date.its easy by copy & past Special option but i want it work with reference.

please help me.
 
Kalpesh39


Firstly, Welcome to the Chandoo.org Forums


I will encourage you to read the 3 Green Sticky posts on the main Forum Page

http://chandoo.org/forums/

These 3 posts explain how the Forums work


You have provided very limited data for which to base an answer

I think if you read this post you will find your solution

http://chandoo.org/wp/2011/11/18/formula-forensics-003/


If that doesn't help try uploading a sample file of your problem
 
Hi, kaspesh39!


I agree with Hui about the insufficient data you posted so as to intend helping you. The only thing that I can add without trying to guess when does the world will end is to suggest you to give a look at this file:

http://dl.dropbox.com/u/60558749/how%20to%20give%20rows%20reference%20to%20columns%20%28for%20kalpesh30%20at%20chandoo.org%29.xlsx


BTW, please take a little of time and go to the three green sticky topics mentioned upwards.


Regards!
 
thanks Mr.Hui & Sir JB7

i got what mistake i made to make question & i am sorry for that sir JB7 i got Sheet Attached by you & thanks for the Same,


what i exactly i need is in sheet1 data like under given format

A B C D E

coll center date1 date2 date3 date4 >>> so on


center1


center2


center3


center4

so onnnn


now i want Separate Sheets for each collection Center ex. as below

A B

Center1

DATE1 (AS GIVEN IN SHEET 1) (VALUE GIVEN UNDER DATE1 OF SHEET1)

DATE2

DATE3

DATE4


hope you got this if not please inform me i can mail you a sample workbook
 
Hi Kalpesh39,


Please see this file:


http://dl.dropbox.com/u/60644346/kalpesh39_solved.xlsx


You can go with insert new sheet just enter in cell A1
Code: 
Center-1, Center-2...
and you will get the results (hopefully) :)


Regards,

Faseeh
 
Hi, Faseeh.


i got it

thank you very very much, i can copy & pest it in as many sheet as many centers i have

just i have to change cell value in formula

Thank You Very Much Once Again


thanks,
 
Dear Faseeh,


after download of your Sheet I altered the same as required by me how ever i am facing some problems at the point week Total & Grand Total

i am Attaching the link to file for your reference. kindly download it from

http://www.2shared.com/document/N9ReJPLy/Purchase_Report.html


thanks

Kalpesh
 
Hi kalpesh39,


Glad to know that it worked for you. Can you pin-point what is wrong in the sheet that you just uploaded because the formula is giving correct results? What do you found wrong in that. It is giving correct results for Total & Grand Total.


Waiting for feedback,


Faseeh
 
Dear Fasees,

yes formula is working right Just refer Sheet2 (Named Sounser) i just hav to put 0 manually in Week Total & Last week Total to get Perfect Result In column Balance But Still i am happy coz i am saving Lots of Energy To maintain this records

Thanks.


and yes i spend most of my time at site where i am unable to connect with Internet & Telephone thats why i am Getting Late to reply, Sorry for that
 
Hi kalpesh39,


Well i did't meant to taunt i just wrote i am waiting unintentionaly. :)


With refrence to you problem of zeros in Week Total & Last Week Total please replace the existing formula in Column B of Sounser's Sheet with this one:


Code: 
=IF(ISNUMBER(OFFSET(B3,0,-1))=TRUE,OFFSET(INDIRECT("Sheet1!A"&(MATCH($A$1,Sheet1!$A$2:$A$999,0)+1)),0,ROW(Sheet1!B1)),0)


....hopefully it will solve this issue.


Regards (..and waiting :D )

Faseeh
 
Hi, kalpesh39!


You can find information here: http://chandoo.org/wp/

Or you can contact Chandoo directly at: http://chandoo.org/wp/contact/


Regards!
 
You must log in or register to reply here.
Back
Top