LauraEdson
New Member
- Joined
- Jun 19, 2013
- Messages
- 1
Hello Everyone,
I've created a form on Excel & I'm having a few problems trying to get it to do what I'd like.
I have two columns on the first page of my excel sheet. The first column has drop down boxes with the options "A", "B" or "C". The second column contains a description which changes everytime the form will be used.
On the second page of my spread sheet I have three horizontal boxes with several lines of space within each. They are headed "A", "B" and "C". I am therefore wanting to be able to select "A", "B" or "C" in the first sheet and enter a description which then automatically transfers the description onto the second sheet under the "A", "B" or "C" heading (which ever one may be selected at the time). I have already used this formula:
=IF('Sheet1'!C17="A","='Sheet1'!D17:K17")
In hope that if A is entered into C17 on the first sheet, it'll then copy exactly what was in the cells D17:K17 on Sheet One onto the Cell A24:I24 on the second page. It does work to some extent and when "A" is selected it does copy across the "='Sheet1'!D17:K17" part but that's it - it doesn't actually transfer the description across.
I've created a form on Excel & I'm having a few problems trying to get it to do what I'd like.
I have two columns on the first page of my excel sheet. The first column has drop down boxes with the options "A", "B" or "C". The second column contains a description which changes everytime the form will be used.
On the second page of my spread sheet I have three horizontal boxes with several lines of space within each. They are headed "A", "B" and "C". I am therefore wanting to be able to select "A", "B" or "C" in the first sheet and enter a description which then automatically transfers the description onto the second sheet under the "A", "B" or "C" heading (which ever one may be selected at the time). I have already used this formula:
=IF('Sheet1'!C17="A","='Sheet1'!D17:K17")
In hope that if A is entered into C17 on the first sheet, it'll then copy exactly what was in the cells D17:K17 on Sheet One onto the Cell A24:I24 on the second page. It does work to some extent and when "A" is selected it does copy across the "='Sheet1'!D17:K17" part but that's it - it doesn't actually transfer the description across.