Excel copy and past macro RRS feed

  • Question

  • Hi, I am trying to record a macro to simple copy all the values on tab a to tab b, but I am using CTRL + A to select only the valid cell and passed on tab B and works great but when I passed a new data in tab A and if, for some reason, have more lines than the previous one excel did not copy and past all the date just the column previous use, I check the macro and instead of copy all CTRL + A excel marked the  last cell but every time the last cell it will be different. How can I make to excel copy all the data in the tab and move to another tab if the data is  different all the time I don’t want to just select all and copy because take forever to do it I just want to copy the validat date any help?

    Fernando Salgueiro

    Wednesday, July 24, 2013 6:00 PM