Is it possible to shorten this code?

Hi,



it seems you are copying a column and then pasting it back into the same column?? (or are you simply trying to get rid of formulas from the input sheet "not inc 8%"

it is a bit late so I may be missing the bleeding obvious, for which I apologiser

Jmac

Originally Posted by jmac1947

Hi,



it seems you are copying a column and then pasting it back into the same column?? (or are you simply trying to get rid of formulas from the input sheet "not inc 8%"

it is a bit late so I may be missing the bleeding obvious, for which I apologiser

Jmac

Basically I have an input page ("Input Page").. "Not inc 8%" has formulas that pick up the date in B1 and matches the name and information from the input page and basically copies and pastes as values for the date picked up.

There's probably a better way but that was what I could do with my knowledge ha!

My experience says Millz generally gets very close so tghat is worth a try I would say, failing that you should probably go back to first principles and post a sample workbook with data and expected results.

That will focus our minds on the exact problem, rather than what we think you problem is.

Jmac

Originally Posted by jmac1947

My experience says Millz generally gets very close so tghat is worth a try I would say, failing that you should probably go back to first principles and post a sample workbook with data and expected results.

That will focus our minds on the exact problem, rather than what we think you problem is.

Jmac

Zip file has been attached to original post.. Full spreadsheet that should work.. could you please have a look at it (modules are abit of a mess but mostly follow one another)

Originally Posted by jmac1947

My experience says Millz generally gets very close so tghat is worth a try I would say, failing that you should probably go back to first principles and post a sample workbook with data and expected results.

That will focus our minds on the exact problem, rather than what we think you problem is.

Jmac

Zip file has been attached to original post.. Full spreadsheet that should work.. could you please have a look at it (modules are abit of a mess but mostly follow one another)

Originally Posted by Izandol

What is connection between B1 value and columns? The dates do not seem to correspond?

Columns include formula to convert to text and match up like two co-ords.

In input screen put 13/06/15 for example in orange box
yellow box "Altrincham" box to the right 1000 and you will see on "not inc 8%" that the value has been posted in the Jun 15 column

Originally Posted by Izandol

I mean what is connection between May 13 and column GK in this code?

Please Login or Register  to view this content.

That may be wrong check from jan14 onwards see if that makes sense. (I have removed or added a few rows and only updated the macro for the months that hadn't had info included)