I have a spreadsheet to track various sales. On the main summary sheet I have just a description, amount and source of sale(like ebay or local). Another sheet I use to calculate my net from ebay sales, with calculations for ebay and paypal fees and shipping charges and costs. I have another sheet for a different site.
Currently if I sell something on ebay I enter the data on the ebay sheet to calculate the net, and then manually enter the description and net on the main summary sheet. What I wonder is if it is possible to have the net, description, and source(ebay in this case) automatically entered/transferred to the summary sheet. I’m willing to research how to write a macro for this, but need to know if it is even possible.