Hi every one
I need help to automate a copy and paste and do not know the best way VBA or formula.
I have a spreadsheet where data is pasted into the first sheet an extra two columns are updated on this sheet by the person who pasted the info.
The second sheet is a breakdown of the raw data, using formulas and look ups to make more sense of the original data.
At present I had use a basic = sheet1(c2) to copy the data to the second sheet and copied the formula down the page, unfortunately this makes the book too big and slow.
What I want is everything on the first sheet to automatically populate the second sheet so that my extra formulas in my extra columns can work.
What in your opinion is the best way to do this VBA? or is there formula Match/ index that will do the job?
Thanks in advance
I need help to automate a copy and paste and do not know the best way VBA or formula.
I have a spreadsheet where data is pasted into the first sheet an extra two columns are updated on this sheet by the person who pasted the info.
The second sheet is a breakdown of the raw data, using formulas and look ups to make more sense of the original data.
At present I had use a basic = sheet1(c2) to copy the data to the second sheet and copied the formula down the page, unfortunately this makes the book too big and slow.
What I want is everything on the first sheet to automatically populate the second sheet so that my extra formulas in my extra columns can work.
What in your opinion is the best way to do this VBA? or is there formula Match/ index that will do the job?
Thanks in advance