Match data and paste if data matches from other worksheet
$2-8 USD / hour
已取消
已发布大约 11 年前
$2-8 USD / hour
I need to be able to match data in a column of one sheet with the data in another sheet and if they match then paste the information from another column. The data I need to match is in Column F (sheet is named [login to view URL]) and i need to match it with column A of the second sheet (named [login to view URL]) And I need it to insert the information from Column D of Price-master into column C of [login to view URL] if the data in Column F and A match.
Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards!