autofil cells

Hi, Please help me to find the code what I am looking for..Tried a lot of variation but I couldn't make the perfect code. So the situation is I made a riport every day and I have to copy the data from another file under the previous days lines. This part is working. After that I have to fill...

Hey guys. I will try and explain this in as much detail as I can and hope you understand! So effectively i have a data set of around 370,000 rows of data, one row (price) for every minute of the year. However, there are many minutes that are missing and thus i need to flag them as missing by...

Dear, I have data like this SHORT LONG NOUN MODIFIER ATT N1 ATT V1 ATT N2 ATT V2 ATT N3 ATT V3 CHEMICAL,FAST-DRY SELF VULCANIZING CEMNT CHEMICAL, TYPE:FAST-DRY SELF VULCANIZING CEMENT, PACK SIZE:236.6ML CHEMICAL -- TYPE PACK SIZE CHEMICAL,FLUSH,LOCO,236.6ML CHEMICAL,FLUSH...

Hello Everyone I have been assigned a task to create a auto fill function. The task is I need to create a formula to search a particular alpha numeric word in a column and define how many times this word as appeared in that column. For example lets say a alpha numeric word called "MIKE1" in...

Hi guys, I have a sheet like: <tbody> SKU price H100L200-245-PK10 1.09 H100L200-245-PK100 10.62 H100L245-290-PK10 1.37 H100L245-290-PK100 13.26 </tbody> Now, in simple human logic, I need pack of 10 to take the price of it's 100 pack version. So, cell b2 (1.09) becomes 10.62. Cell...

Hi, I want to use AutoFill function. In destination value I start in point E13 but END values is dynamically counted, so I can't use Range-> Range("E13:E" &....). Selection.AutoFill Destination:=ws2.Cells(13, s), Type:=xlFillDefault My autofill destination is like: E13:AA13, or E13:CC13.....

Hello Ladies and Gents, I am trying to create an automatically filled text box based on the text value of two other cells. Please see the example below. I have on another sheet two drop down lists, one to select the customer, the second recognises which customer has been selected and then...

Hi all Excel Members, I have a function that checks if the text content in two textcells on same row on column J and column K is the same. when two equal cells find same row (column J and column K), go to Column A check which number is (for example, in this case, "34234") select column B...