Forum Discussion

Copper Contributor

Mar 02, 2021

Copy row from one sheet to another based on cell

Hi, I'm trying get rows from table 1 pasted into correct sheet based on cell value. I've attached an example of what I'm trying to have automated. You'll see that there are 3 x sheets. If ...

Draft.xlsx41 KB

excel

Formulas and Functions

Macros and VBA

kmohanreddy20051735

Copper Contributor

Mar 02, 2021

Nelz_ Hi, Here you go. I have written a small VBA program to achieve this task. If it is resolved your query, can you please like rate as best answer?

Draft.xlsm48 KB

Nelz_

Copper Contributor

Mar 02, 2021

Hi,

Sorry I had put up a rough temp with dummy names. I have about 66 different 'Place' & specific company names I need to use for 'Feed'.

How would I go about adjusting in VBA program you set? Other than that, the workbook is exactly what I need

Thanks!!