Mar 28, 2011 at 05:36 PM
Posts4478Registration dateThursday January 28, 2010StatusContributorLast seenMay 5, 2022
Mar 31, 2011 at 11:11 AM
What I am trying to do is copy a cell from tab one (always the same cell) and then look for it in a column in another tab. Once I have found the unique row with that data in it I want to copy the entire row and paste special values the row, thereby removing formulae with numerous vlookups which are only used once.
We have a pricing spreadsheet so on updating the next date in the cycle in the cell mentioned above, the macros should go to the pricing spreadsheet, look for the date that was entered in the cell and then copy the row that has this date.
Can anyone help as basic macros I am ok with, this is out of my league!