Hello and let me say I am sorry if there are variations of my question posted but I could not find any and I am green.
I need help please
I would like to get a code to do the following pls.
pick the value in cell a1
copy range b2:s90 in that same worksheet
copy as picture
paste as picture in a different yet an existing workbook
create new worksheet
name new the work sheet as the value from a1 from the 1st worksheet
please advise here is what I have so far
If Worksheets("Report").Cells(2, 2).Value <> "CarDEALER" Then
Worksheets("Report").Cells(2, 2).Value = "CarDEALER"