LABEL COUNT
1 of 2
empty cell
1 of 2
empty cell
1 of 2
empty cell
1 of 2
empty cell
1 of 2
empty cell
1 of 16
15 empty cells
I need to fill the empty cell with the "series" (2 of 2, 2 of 16, 3 of 16). This is just an example of data - there are all different series - 1 of 12, 1 of 5, etc.
Anyway - was hoping to highlight the whole column and be able to auto fill instead of having to extend each series. I have tried straightforward fill series which doesnt work of course. I have tried go to special - blanks but cant find right combo to make it work.
Will it work or do I have to either do manually or with a macro?
I am working on a spreadsheet and I need values from Sheet1!a2, a7, a12, a17 etc...
I want to fill in the formula ='Sheet1'!a2 etc, to fill column A in sheet2!
When I highlight and drop down to fill excel fills the column in increments of five like i need but doesn't start on the right one. Instead it fills the formula as ='Sheet1'!a6, (For cel A1) and ='Sheet1'!a11, (for cell A2) and so on.
I am trying to use the auto fill series but I need the series to start over every time the value change in another column.
If i use the auto fill series, it will copy 1,2,3,4,5 and so forth til the end of the column. In this case, i need the auto fill or some other function that will restart once it encounters a different value under the ID column. I've started below to show an example.
I am trying to read a value in cell A1 and make say cell B1 read the same. The data in cell A1 is a real time percentage value that gets updated every lets say 10 secs. Every time the data is updated the new value goes into the next cell A2, A3, A4..... and so on. Every time it gets updated (i.e into A1,A2,A3,A4.....and so on), I want to read the new value each time in B1.
I have a worksheet with Coulmn A and B , wherein , Column A has a list of values that can be duplicated. Based on the values in Column A, I want to fill corresponding cells in Column B. see the attached.
I want the macro to go to column F and copy down from the row containing AO NAMES down to the row containing TOTAL with the value within cell C3.
So basically AO NAMES will be the starting point and TOTAL will be the end point for a value to be copied down in a different column.
Example: Value in C3 = EU11
Column B Column F AO NAME EU11 Chris Wright 1355 EU11 Hazel Thomas 4015EU11 Julie Cunningham 8426EU11 Dawn Cumming 8748EU11 Jacqui Connolly 16597EU11 David Newton 17978EU11 Duncan Cowen 25781EU11 0EU11 0EU11 0EU11 0EU11 0EU11 TotalEU11
I've received a data report where the brand is in an incorrect format, but can be calculated from data in the list.
I have Brand in the format CRY, but it should be in the format CRYS or CRYW (brand + tag for winter or summer). There are other brands that behave in the same way, e.g. THO should become THOS or THOW, PLA should become PLAS or PLAW, FIN should become FINS or FINW.
I've created a new column using IF statements in conjunction with the departure date to work out whether it was a summer or winter booking, and as a result column C is now populated with either Summer13, Winter13/14 or Summer14.
I don't particularly care if it's a summer 13 or 14 booking, they get reported on together. So I now have the brand alongside the season (summer or winter). I built a database to use with the DGET formula:
Brand Season Result
CRY Summer13 CRYS
[Code] ........
And I used DGET to work out what the result should be in column F:
=DGET($N$4:$P$16,"Result",B1:C2)
This works beautifully for Cell F2, but F3 can't seperate the headers (B2 and C2) from the data (B3 and C3) without tripping over B2 and C2.
I need to create a drop-down (or a combo list) list based on a column in a separate worksheet (in the same workbook). The values in the column have many duplications, and I simply want the combo box to return a unique list.
After trying this using various options like drop-down boxes, combo boxes etc it does not seem to work. A drop-down box will return a complete list (including all of the duplicates). In addition the drop-down was linked to a cell and the value returned to the cell was a number based on the position in the list when what I actually wanted was the text. For example - my list in Worksheet 2:
PETS Cat Dog Dog Cat Horse Rabbit...
In Worksheet 1 if I choose 'Dog' from my Combo box (or drop-down) along with showing all of the duplicates it returns '3', instead of what I want 'Dog' and no duplicates.
Prior to declaring a variable i used this code and it worked:
Sheets("442000ON-1+6").Range("C7").formula = "my formula" range(C7).select Selection.AutoFill Destination:=Range("C7:N7"), Type:=xlFillDefault
Than i declared a variable b/c i have a number of formulas i need to use but still needed it to fill the formula in a series after the formula ran. I started getting an error.
Set SourceRange = Worksheets("442000ON-1+6").Range("C7") Set fillRange = Worksheets("442000ON-1+6").Range("C7:N7") SourceRange.AutoFill Destination:=fillRange
I have a list of 600 unique project IDs in column A. I want to create a second list in Column B that references the contents in Column A, first row then duplicates that item for two subsequent rows, then a formula in the fourth row of Column B a reference to the second project ID in Column A row 2, with two duplicates in the fifth and sixth row.
Column A Row 1 000891.AB Row 2 000892.CD
Need to create: Column B Row 1 000891.AB Row 2 000891.AB Row 3 000891.AB Row 4 000892.CD Row 5 000892.CD Row 6 000892.CD
I know very little about macros (basically just concepts). I found this macro suggested in another thread (posted By VoG II…Thanks)
Sub test() Dim Lastrow As Long Lastrow = Range("A5").Value + 4 Range("B5").AutoFill Destination:=Range("B5:B" & Lastrow), Type:=xlFillSeries End Sub
When this macro is run the first time it will fill in the numbers 2 through 15 (as I had hoped). Given 15 is the variable and 1 is the start of the range...
I would like to find the blanks within a column. Using the available cell values above and below compute a sort of linear function then, using that linear function fill in the blanks in between. So the values are linearly increasing or decreasing (whatever the case maybe) to the next available nonblank cell value. spreadsheet attached.
i have a time series of data at one hour interval ( from 6:00 hrs to 18:00 hrs ) each day and again from 6:00 to 18:00 hrs next day and so on for several years. in this series many data are missing. i ve to fill in these missing data in such a manner so that the new values becomes the linearly interpolated values in between the data given at any two hours. no rows are allowed to be inserted in between 18:00 hrs of the previous day to 6:00 hrs on the next day. pl see the attatchment.
I have a spreadsheet where the start date is manually entered in Cell B1 and an end date is calculated in Cell B3. I would like to have the dates between the start and end date, with a step value of 7 days show in the rows under Cell B3. How do I get this to work?
regards the two attached files (both are identical) except '1' has TWO Rows of data above the Macro Button and works correctly whereas '2' has only ONE Row (the desired option but does not work correctly!( Inserts Row in wrong place and incorrectly fill series)).
basically the program inserts a additional row below the last data entered, copies a formula cell from above and finally (the problem area) Series Fills a cell from data above.
I am newer here and I want a macro in mentioned title. I have a number in column a2 and in column b2 quantity if in column a2 number is 2101400 and in column b2 i write quantity 50 so said number automatically fill series in column a like mentioned below...
I have a spreadsheet with two sheets... Sheet1, and Sheet2, that I use as sort of a staging area to format info before bulk uploading to my product database. The products I'm working with at the moment have 10 subcategories below each of them. Sheet1 is the full product database listing. I place new subcategories in blocks of 10 that I plan to add to the database on Sheet2. Sheet2 also holds the default partial category names in cells A2-A11.
Part 1:
I am currently using the following formula on Sheet2, in column C to combine the category name value on Sheet1, with the default partial category name values on Sheet2 (A2-A11). I'll paste two blocks so you have a clear picture of what I mean by blocks of ten.
I have a excel sheet of data numbers which blongs a packet of inventory where i found number series like this:
Start Range End Range Qty 2101200 2101499 300
I have to draw this onto a series like 2101200 then 2101201 then 2010202 etc. but some time these numbers are in qty 30000 or more. I have questions
1- If any macro colud fill series suppose if write number in A2 and qty in B2 so it reads the qty of b2 and fill the series in A. If i write 1 in A2 and write 50 in B2 so the series should be auto fill 1 to 50.
My Second question is opposit of my above question.
2- if i have different number series in column a and i want them to be as start number in column b and end number in column c and qty in column d based like mentioned below example. Series [b]Start Range End Range Qty 1 1 1 1 3 3 3 1 5 5 7 3 6 7
I am using Excel 2010 and have the problem as shown in the attached file.
Input Sheet shows the Data I have at present Output Sheet is the desired result.
I need a macro which should create an "Output" sheet by doing the following on the Input Sheet
1)Insert a Blank Column before Column A 2)Unmerge the Region Heading and insert the respective Region Name in the newly inserted Column. Region Heading will be in Bold Font. 3)Repeat Step 2 for all Regions 4)Delete the Rows which was merged.
Please note that the number of Data Rows will vary for each Region.
I have shown two Regions for explanation purpose only. There will be several Regions in reality.
I have a listbox that has row and columns. The rows are combinations of options and the columns are Additives.
After selecting a row in Listbox1, (first column are names) i would like the value of the second column to goto a specific area.... find that value and in the cell to the right of it place a "Y". The "Y" would indicate that "yes" it was part of the selection row of the listbox. Same for third column, forth, fifth and sixth. The result from the listbox is a number of Y's and N's in the result page. Then making all that were not part of selected line and equal to "N" to hide row (height = to zero).
Listbox and expected result are in attached example worksheet.
The attached does show the need much better then I can explain it.
