|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 18th, 2009, 03:14 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
problem with formulas
hi, i have problem in dragging the formulas if i give cell reference in a1 for ex =Sheet2!A1 in cell a1 in sheet 1 i couldnt drag the formula to cell b1. If i drag the formula it is showing as =Sheet2!B1. instead i need it like =Sheet2!A2 But when i drag horizontally the formula is working but i couldnt copy and paste as it is not working. Please help -- Sathisc ------------------------------------------------------------------------ Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97698 
|
|
#2
May 18th, 2009, 03:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem with formulas
Hi,
Try this =INDIRECT("Sheet2!A"&COLUMN(A1),1) Mike "Sathisc" wrote: hi, i have problem in dragging the formulas if i give cell reference in a1 for ex =Sheet2!A1 in cell a1 in sheet 1 i couldnt drag the formula to cell b1. If i drag the formula it is showing as =Sheet2!B1. instead i need it like =Sheet2!A2 But when i drag horizontally the formula is working but i couldnt copy and paste as it is not working. Please help -- Sathisc ------------------------------------------------------------------------ Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97698
|
|
#3
May 18th, 2009, 03:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem with formulas
OOPS,
Try this instead. =INDIRECT("Sheet2!A"&COLUMN(A1)) Mike "Mike H" wrote: Hi, Try this =INDIRECT("Sheet2!A"&COLUMN(A1),1) Mike "Sathisc" wrote: hi, i have problem in dragging the formulas if i give cell reference in a1 for ex =Sheet2!A1 in cell a1 in sheet 1 i couldnt drag the formula to cell b1. If i drag the formula it is showing as =Sheet2!B1. instead i need it like =Sheet2!A2 But when i drag horizontally the formula is working but i couldnt copy and paste as it is not working. Please help -- Sathisc ------------------------------------------------------------------------ Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97698
|
|
#4
May 18th, 2009, 03:39 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem with formulas
In article , Sathisc wrote: hi, i have problem in dragging the formulas if i give cell reference in a1 for ex =Sheet2!A1 in cell a1 in sheet 1 i couldnt drag the formula to cell b1. If i drag the formula it is showing as =Sheet2!B1. instead i need it like =Sheet2!A2 But when i drag horizontally the formula is working but i couldnt copy and paste as it is not working. Please help Try... A1, copied across: =INDEX(Sheet2!$A:$A,COLUMNS($A1:A1)) -- Domenic http://www.xl-central.com
|
|
#5
May 18th, 2009, 03:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem with formulas
Drag across the columns (the way that works)
then, in A2, enter: =TRANSPOSE(A1:Z1) copy A2 then, highlight from A2 - A27. Hit Shift+Ctrl+Enter to enter as an array formula. "Sathisc" wrote: hi, i have problem in dragging the formulas if i give cell reference in a1 for ex =Sheet2!A1 in cell a1 in sheet 1 i couldnt drag the formula to cell b1. If i drag the formula it is showing as =Sheet2!B1. instead i need it like =Sheet2!A2 But when i drag horizontally the formula is working but i couldnt copy and paste as it is not working. Please help -- Sathisc ------------------------------------------------------------------------ Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97698
|
|
#6
May 19th, 2009, 10:37 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem with formulas
thanks everyone it works perfect -- Sathisc ------------------------------------------------------------------------ Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=97698
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
