aadityapatel1984
New member
- Joined
- May 2, 2014
- Messages
- 3
- Reaction score
- 0
- Points
- 0
I have one excel sheet in which first row having multiple columns how to fetch cell data from each column of first row?
How to fetch data from first row
- Thread starter aadityapatel1984
- Start date
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- Excel 2016
We may need a bit more specifics.....
but here are a couple of ways....
You can simply point to the first cell, then copy across.
e.g. =Sheet1!A1 and copy across.
or
=INDEX(Sheet1!1:1,COLUMNS($A$1:$A1)) copied across.
where Sheet1 is sheet you have the data in.
but here are a couple of ways....
You can simply point to the first cell, then copy across.
e.g. =Sheet1!A1 and copy across.
or
=INDEX(Sheet1!1:1,COLUMNS($A$1:$A1)) copied across.
where Sheet1 is sheet you have the data in.