Ending value in a specific row passed to a specific cell

[djfscouse]

Hi,

I have a set of csv files that in column B the ending value changes, is there a macro that I can run on that column which can take the last value in that column and copy it to cell P1

Thanks for any help,

David

[stnkynts]

This may be a stupid question but are the csv files in such a way that you can use the "=Right" function? That would remove the need of a macro.

A macro would probably go something like this:

Please Login or Register  to view this content.

[djfscouse]

Hi stnkynts,

Unfortunately I need to use a macro so I can press a shortcut key it will automatically search that column and return the value at the end of that column and copy it to the cell P1.

I tried your macro but it copies the values from B to column P.

Thanks for the help anyway,

David

[djfscouse]

Does anybody have an idea on how this could be done?

Thanks,

David

[stnkynts]

So you just need the last value in column B put in cell P1? Thats fairly easy:

just put this formula in cell P1. It should automatically update.

Please Login or Register  to view this content.

by macro

Please Login or Register  to view this content.

[djfscouse]

Perfect! Thanks for your help.