Forum Discussion
copy and paste an excel sheet to a current excel template we use need formula to filter amounts
We use a template that we've been manually entering per line item and entering data in the correct row/cell.
we are now able to copy and paste data to the template, however, which formula do I use to have the amounts being filtered in the correct row?
- would you kindly attach a 'dummy' file so people here can have a better view of your query... thanks
first tab - month I want to copy and paste onto thecopy and paste tab
2nd tab - previous month details - shows how we separated each expense
3rd tab - this is where I would just like to copy and paste the new months data and based off the description, I would create a formula to autofill to the correct row
there are many good people here in the forum that may help you.
good luck..
