I have a price sheet with over 100 items.
I would like to be able to change the percentage in A7 that would make the change in corresponding product such as f7
also make the change in B7 that would make the change in the other corresponding cells.
Is this possible
Dave
In A7, change to .36
In F7 change to =A7
In each cell that now has Exchange 36%, change to =A7
In each B7 change to =(B5+B6)*1+A7. Make similar changes in the other cells that you wish to have pricing generated by the value in the percentage cell.
Posting Permissions
Reply With Quote
Bookmarks