MatthewField
New Member
- Joined
- Jan 5, 2018
- Messages
- 8
Firstly, i'm new to Macro's and to Mr Excel so apologies if this question has been answered elsewhere within the forums but i'm hoping someone can help and this is an easy fix.
I'm trying to automatically populate a VLOOKUP formula in each cell of Column C but only when there is a value entered in the adjacent cell in Column B.
I'm aware of the easy approach of copying and pasting the formula down the entire sheet, but this causes a problem when printing, as even though there is no values there it knows there is a formula waiting in each cell of Column C which then means it prints hundreds upon hundreds of pages. I'm aware of why this is happening to stop that, other users of the spreadsheet won't be.
My spreadsheet looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Item Type[/TD]
[TD]Printing Process[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]05/01/2018[/TD]
[TD]Covers[/TD]
[TD]=VLOOKUP(B2, Fields!$B$5:$C$24, 2, FALSE)[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The VLOOKUP a separate table within a different sheet but the same workbook to select the appropriate printing process for the selected item type. This formula works perfectly but I would like for it to automatically enter it on to the next cell down only when someone has selected an item type (Column B)
I would greatly appreciate any advice and help if you can.
Many thanks,
I'm trying to automatically populate a VLOOKUP formula in each cell of Column C but only when there is a value entered in the adjacent cell in Column B.
I'm aware of the easy approach of copying and pasting the formula down the entire sheet, but this causes a problem when printing, as even though there is no values there it knows there is a formula waiting in each cell of Column C which then means it prints hundreds upon hundreds of pages. I'm aware of why this is happening to stop that, other users of the spreadsheet won't be.
My spreadsheet looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Item Type[/TD]
[TD]Printing Process[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]05/01/2018[/TD]
[TD]Covers[/TD]
[TD]=VLOOKUP(B2, Fields!$B$5:$C$24, 2, FALSE)[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The VLOOKUP a separate table within a different sheet but the same workbook to select the appropriate printing process for the selected item type. This formula works perfectly but I would like for it to automatically enter it on to the next cell down only when someone has selected an item type (Column B)
I would greatly appreciate any advice and help if you can.
Many thanks,