d11

I need a small VBA to copy and paste from one sheet to another, with a catch... Sheet1 is the source sheet and has dynamic data ( Numbers ) from d11 to d110. Sheet2 is the destination sheet and the data needs to be pasted in d11. Later... new data is input into Sheet1....this new data from...

If I have a table with average ratings of a number of products by people who were given the choice of rating them on a -5 to 5 scale. (1-5 thumbs up, 0 thumbs, 1-5 thumbs down.) These products got generally negative ratings, which makes the relative ratings a little difficult to visualize. To...

I require 24 hour time to be formatted in cell D11. What happens is the actual time may not get entered until later on Example: The current time is say 13:30 but i need to enter the actual time achieved which was 10:30 in D11 What is the easiest way to achieve as i want 24 hour displayed...

Hello, This is my very first post so pardon any faux pas, plus I am only a beginner at teaching myself VBA so please excuse any knowledge gaps. I've been trying to Frankenstein codes from too many forums and just can't get what I want to do done. My conundrum (and I will try to be as specific...

Hi, I would like to create a User Defined Function (UDF) from a complex calculation in an excel sheet. Illustrated as in the screeenshot below: - Value D11 is calculated as a sum of D6-D10, which are in turn complex IF functions. - Now I would like to have somthing like...