B
brian
I have a 800 line spreadsheet with 10 colns. One coln is
%Margin by invoice. I want to sort my spreadsheet by
product for easy input of each individual margin and then
link to original spreadsheet so each invoice reflects
revised cost by each margin. I tried having the data in one
sheet, first by invoice, second by margin. When I sort,
they both sort. I then tried two separate sheets that are
linked. However with linkage, it appears to link by row
rather than specific product code.
Thank you for the info...........Brian 403-742-2000
%Margin by invoice. I want to sort my spreadsheet by
product for easy input of each individual margin and then
link to original spreadsheet so each invoice reflects
revised cost by each margin. I tried having the data in one
sheet, first by invoice, second by margin. When I sort,
they both sort. I then tried two separate sheets that are
linked. However with linkage, it appears to link by row
rather than specific product code.
Thank you for the info...........Brian 403-742-2000