Horizontal autofill from vertical data different sheet
Hi all Master
Here My first thread
My Name is Cipta
Could any body help me for autofill horizontally from other sheet vertical data.
Vertical Data
Sheet1
A1
A2
A3
A4
& so on
AUTOFILL HORIZONTAL DATA
Sheet2
D3,D4,D5,D6..... fill by A1 A2 A3 A4.....
Regard
In Sheet2!D3
=INDEX(Sheet1!$A$1:$A$100, COLUMN(A1)) copied to the right
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Dear
Chemist
wow, it is work, thank you.
Regard
Chiep
Chemist
but how if I use this formula =IF(Sheet1!A1="","",Sheet1!A1) and drag horizontally it is'nt work, any have idea to modify this formula, or it is the same function with =INDEX(Sheet1!$A$1:$A$100, COLUMN(A1))
regards
Chiep
Yes,
=IF(INDEX(Sheet1!$A$1:$A$100, COLUMN(A1))="", "", INDEX(Sheet1!$A$1:$A$100, COLUMN(A1)))
yesssssssss wow
It's work well
Great thanks
Chemistb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks