Hello,
I'm trying to write a macro to do the following:
- In a sheet, auto fill the column "Adjusted" with the values in the column "PM"
- Only auto populate the column of the active sheet, as this is a shared workbook. I do not want to overwrite other people's work.
Is this possible? I've attached my workbook with the six tabs. I have not been able to figure this out. Thanks for any help!
you have a lot of columns named PM and about as many named Adjusted.
You'll have to be more specific about which column you want to autopopulate and with which data.
Are you adding multiple PM column?
Please advise.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
I would like the PM column for each color (named AMS46, Borg, etc) to populate the column next to it labeled Adjusted. So, you would see the same values in each column for each color
the following macro will work on the PM Input sheet only as all your sheets have different number of rows used as titles.
If you can make all your sheet first rows all the same, you could use only one macro.
One way around this would be to ask your operator to select the first PM cell in the table before running the macro.
You could also add a check in the macro to make sure he or she has selected a cell with PM in it.
The whole macro is based on the activecell.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks