Auto Populate Columns, two worksheets

[anarcticfox]

Hi all,

I am trying to do this:

On Workbook 1, when Column AH has the value W, then on Workbook 2, on the next blank row, assign the next job number(Q1234...) and auto populate the remaining details from the Row which had the value W, in Workbook 1.

Is this possible?
I tried everything I could from my knowledge and I have now reached a dead-end.

Help,
Sven

 

[Dantrith]

This isn't a VBA solution, but it is what I use.

Copy the information to the worksheet that you want either via a linked table, or vlookup formula, it doesn't really matter.

Make another column your job number column and then put =IF(E19>0,MAX($L$17:L18)+1,"") (or equivlent, I just copied that from a sheet I used to give unique values) Basically it takes a max of all values above it and then adds one.

Then you can filter it by unique value column.

It may be more trouble than it's worth but that's how I assign unique values.