muddyspudz
New Member
- Joined
- Jan 14, 2021
- Messages
- 1
- Office Version
- 2011
- Platform
- Windows
Hi, I'm not sure if i can explain this well but what I have is a column of numbers on 1 sheet, column A,
these will be manually put in over time, so 1 and each row has information that i need to send to another sheet if the number matches
the number on my other sheet, in the cell J30, then if the number matches i would like to copy certain cells from sheet1 to sheet2.
I'm not sure how to do this, as i need it to match the cell J30 only.
That is what I would like help on if possible please,
I'm sorry to be a pain.
so in recap,
the user will enter 1 in column A on sheet 1,
I would like this number to look at cell "J30" on sheet 2 and if it matches this number (1)
then have the macro copy cells "D5, F5, G5 and H5 from sheet 1, to sheet 2 cells "A13, C13, F13 and J13.
if the number does not match i would like the macro to ignore it and carry on until all the rows with this number have been copied.
i will also need to do this for numbers 1 -26, (in column A on sheet 1)
if someone can help get me started that would be amazing, again sorry if this is confusing i will of course answer any questions.
Thank you so much.
these will be manually put in over time, so 1 and each row has information that i need to send to another sheet if the number matches
the number on my other sheet, in the cell J30, then if the number matches i would like to copy certain cells from sheet1 to sheet2.
I'm not sure how to do this, as i need it to match the cell J30 only.
That is what I would like help on if possible please,
I'm sorry to be a pain.
so in recap,
the user will enter 1 in column A on sheet 1,
I would like this number to look at cell "J30" on sheet 2 and if it matches this number (1)
then have the macro copy cells "D5, F5, G5 and H5 from sheet 1, to sheet 2 cells "A13, C13, F13 and J13.
if the number does not match i would like the macro to ignore it and carry on until all the rows with this number have been copied.
i will also need to do this for numbers 1 -26, (in column A on sheet 1)
if someone can help get me started that would be amazing, again sorry if this is confusing i will of course answer any questions.
Thank you so much.