Hi, all,
I have the following problem
I have a file, in which a new sheet is added every month with new information. My aim is to create a macro on a ceparate worksheet((named Macro) in this file, that goes into the sheet for the respective month, based on cell refference. For ex, if A2 = Jan16, go to sheet Jan16. Then it should filter the values that are not equal (for ex- the movement of the prices of articles through the year plus the current month). For that purpose I have added a new column in each sheet, comparing the values, so the Macro should go to this column (AO, refresh and filter the "false"(If the price is the same- no action. If not- copy the range of materials- visible cells only in cell range A4-T4 (and right untill we have values as each month there will be a new column) untill the bottom where we have values, and paste special in sheet Macro, values, transpose (the months to be vertical, the article numbers- horisontal.)
I have read a lot and tried to create a VBA code - simple macro copying my actions. But I receive an error message. The code works well when I simply go into a sheet and copy paste special the values. But when I try to update the code with refference to the cell A2, the macro doesnt work, and I receive an error message for the copy paste special/transpose part, not for the part of the cell refference.
Could you please advise what i should do? If additional information is needed- just let me know.
Thanks to all!
I have the following problem
I have a file, in which a new sheet is added every month with new information. My aim is to create a macro on a ceparate worksheet((named Macro) in this file, that goes into the sheet for the respective month, based on cell refference. For ex, if A2 = Jan16, go to sheet Jan16. Then it should filter the values that are not equal (for ex- the movement of the prices of articles through the year plus the current month). For that purpose I have added a new column in each sheet, comparing the values, so the Macro should go to this column (AO, refresh and filter the "false"(If the price is the same- no action. If not- copy the range of materials- visible cells only in cell range A4-T4 (and right untill we have values as each month there will be a new column) untill the bottom where we have values, and paste special in sheet Macro, values, transpose (the months to be vertical, the article numbers- horisontal.)
I have read a lot and tried to create a VBA code - simple macro copying my actions. But I receive an error message. The code works well when I simply go into a sheet and copy paste special the values. But when I try to update the code with refference to the cell A2, the macro doesnt work, and I receive an error message for the copy paste special/transpose part, not for the part of the cell refference.
Could you please advise what i should do? If additional information is needed- just let me know.
Thanks to all!