auto

Hi I need to move data from 5 rows in one column and to separate columns. The data looks like this <colgroup><col><col><col></colgroup><tbody> Infinity Auto Import 20 Puriri Street, New Lynn, Auckland 09 9512882 View dealer listings IV Cars 90...

Hello Everyone I have a task to find number of cells which contains particular month. The formula used is =SUMPRODUCT(--MONTH('Sheet1!C2:C1000)=1)) , this formula gives data for empty cells also. For example there is data from C2:C500 but when I select the range C2:C1000 the formula gives value...

Hi I have a formatting question, in Sheet1; column H (Due Date) and column I (Countdown to due date), I want date performed + 7 = Due Date and countdown = Today()-Due Date. I no I can use formulas but, is there a way to auto populate without dragging the cells down? Thank you.

How to create button in all cell to triger web camera and click picture and auto save to selected cell...........

How would one automatically adjust a rows height as the cell entry exceeds the column width.Thanks

Hi guys, me again, a VBA beginner. I have the information below:- Column B1:E1 are the description. Then we copy the data from other sources based on these description (FilexxNAME, Nature, Place, Tool). We dunno the total number of the series. It can be 6 series (like example below), or it...

Looking for help. I would like to create a formula that would pull in employees name/s. I have a database I type in employees names and the route each person is assigned to. Each route has its own tab. I want he employees who belong on the route/tab to auto populate. The crew may be one or 6...

1. I have data in Sheet 1 having 2 columns name Description and Range_T and in Range_T "*" is used for advanced filtering for text. 2. In sheet 2 I have Range_T which is having different data and needs to filtered using Range_T as "criteria range" which is dynamic as description data keeps on...

Good morning, I am trying to use this reference to create an auto fill data validation. https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html?page_comment=1 It works great for a normal named ranged. However, it does not seem to work when I'm trying to...

Hi, I am using the advanced filter with two criteria to sort a list. However, I want to use top #10 or top #25 items using auto filter. Is it possible to use top #10 with advanced filter and/or can I use auto filter on the list that I sorted using the advanced filter?

Hi, Can anyone please help me. I want to auto deduct break from total working hours base on several situation. 1) Monday - Friday - 0.5 for =>3hours - 1.0 for =>6hours 2) Saturday - Sunday - 0.5 for =>6hours - 1.0 for =>8hours 3) Public Holiday - 0.5 for =>6hours...

I have a table of data that I need to then auto filter to return a subtotal across 11 columns and the works fine, however what I would really love is a front page to this data that automatically displays set criteria I would normally select to auto filter by. For example when I auto filter to a...

Hi all, im new to macros and was hoping someone can helpme. I need the macro to archive a sheet and store it in my H drive, can anyone help me?

Hello- I want to Auto Rank a list by a Total Score column. The current table was generated using formulas from another sheet that can allow additional rows. I also want to make sure any new or deleted records get reflected in this final table. Thank you <colgroup><col...

Hi, I am using the following code to insert a couple of rows into a worksheet and then select a range above them. I want to be able to auto fill down into these two rows and then change the active cell to the next cell in column A ending with a 5 or a 0. If the second part is not possible...

Hi Every One Hope You will be enjoying good health I'm creating order sheet I'm stuck on one point on auto increment order no I have created below formula =IF(ISTEXT(C2),IF(C2="PinkFit","PF",IF(C2="Gloryshop","GS",IF(C2="Whats...

https://www.dropbox.com/s/9n4y59cfyp7op7d/auto%20sort%202.PNG?dl=0 https://www.dropbox.com/s/45lx6ebsqem8so2/auto%20sort%201.PNG?dl=0 im trying to create a sheet to the pictures above i created manually so you can see what im trying to do. the first picture (sheet1) i would like to have the...

Hi, I was hoping that someone could give me the code for thefollowing. I wanted a pop up box for users to fill in 4 columns ofinformation. Col A would be “Date” B “Site” C “Tonnage” D “Reason” isthere a way that it will auto fill the newt row? So row 1 has the header titleso the info would need...

Hi All, I need to auto populate other cells based on the drop down list selection in excel my drop down consists of data with colon(:) separated, and I need to auto fill another cell with the data For ex. in Drop down user selected data One:Two:Three, in B2 (Column B and Row 2) I need to auto...

Hi Every One. Hope You all were enjoying good health. can anyone help me to generate auto ID based on cell value like...