Hello:

I currently have code that copies data from a data sheet and links it to the sheet names in matching sheets. It looks up Bill from the data tab and takes a range of data from Bills row and pastes it to Bills tab so on and so forth with other names. There could be one Bill item or 10 bill items. The fee structure in Bills Sheet is different from James Sheet etc. so I want to be able to add different formulas in H3 to K3 only if there is data in A3 on James sheet. All formulas will use data only from the active sheet which would be Bills sheet in this case.

Any help would be appreciated. Thanks