Tranferring data between worksheets depending on a couple of variables

[bartonMark]

Hi

I have been trying to get the below to work for a little while now but no luck at the minute, perhaps one of you guys may have better ideas that me?

I have attached a copy of the workbook for reference. What I am trying to do is to populate 'page per pole' with work items in 'field sheet' when the pole number on the 'page per pole' matches the pole number on 'field sheet'. I have allowed 12 lines on 'page per pole' as this is a max I should need. Just need to get the code right to get it working!

Once this is working, I then need to write a macro to create seperate 'page per poles' based on pole numbers in 'field sheet'.

Any help or ideas welcome!

Cheers

Mark

[xladept]

Hi bartonMark,

Welcome to the Forum!

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

*Rename Page per Pole as BlankPole and delete Column B

Nevermind - here it is:PolePages().xlsm

[bartonMark]

Hi XLAdept

Your code got me loads further than I was! Thank you very much for your help, its very much appreciated!

[bartonMark]

Hi XLAdept

Your code got me loads further than I was! Thank you very much for your help, its very much appreciated!

[xladept]

You're welcome and thanks for the rep!

[bartonMark]

Hi XLAdept,

When inputting on the sheet, if I put in a number on the same line for say poles 1,2,3,4,5,6 and 7 - when this is transferring over, the code is summing up all the numbers and putting them in the column instead of displaying the qty in the line under the pole number in the sheet (if that makes sense?). Any ideas how to achieve this?

Cheers

Mark

[bartonMark]

Hi XLAdept,

When inputting on the sheet, if I put in a number on the same line for say poles 1,2,3,4,5,6 and 7 - when this is transferring over, the code is summing up all the numbers and putting them in the column instead of displaying the qty in the line under the pole number in the sheet (if that makes sense?). Any ideas how to achieve this?

Cheers

Mark

[xladept]

Hi,

Yeah, I did that on purpose - I'll try to figure another way

Try this:

Please Login or Register  to view this content.

[bartonMark]

Hi XLAdept

You my friend are an absolute legend!!

Cheers

Mark

[xladept]

Awww Shucks!