fill a series

I have a list of 100 customers which are ranked from 1 to 100. Those are from 1 to 50 should have 2 customer visits per year, the second visit is 6 months after first visit. Customer ranked 1 has visits in Jan and Jun, customer ranked 2 has visits in Feb and Jul, customer ranked 3 has visits in...

Hello I have a data set that has some problems and needs cleanup, but I'm not sure how to accomplish this feat. Basically I want to flatten the data as much as possible without loosing any data. The data came from different sources so each row represents a row, and the column is where the data...

I want . . . A1 = Sun (day of week) B1 = 01-01-17 (date) A2 = Mon B2 = 01-02-17 (=B2+1) . . etc . . A365 = Sun B365 = 12-31-17 (=B364+1) Is there a way to fill/down 7 cells (A1 thru A7) down thru A365 w/o having to copy/past 52 weeks, 1 at a time?

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...

I am having a problem with a fill issue. On a 'Calendar' tab I am trying to fill cells E3 through to AI3. Cell E3 states ='Holiday Leave'!B5, Cell E4 states ='Holiday Leave'!B6. I need this to continue with B7, B8, B9 etc. When I use the fill option it continues a sequence using the Letter...

Hey people, I need help filling a series based on a referenced workbook. Here is my formula: =[CIF9000.xls]Sheet1!$A$1 I want to be able to fill down a series that only increments my referenced workbook. So, filling the series would look like this: =[CIF9000.xls]Sheet1!$A$1...

I have 700 rows of data and keep track of what is the current number of billing (for contractual monthly billing purposes). I am able to use the fill option handle to go from one cell to the next and it will give me the correct sequence, for example 15th to 16th. However when I select the whole...

Hi there , i have a data set that is populated in a table , there are two set of data. one are fixed points such as time , location . The other are variables specifically its a test number and test depth. For each sheet there are different amount of values . One test might have 30 rows of...

Hi All, I have a worksheet that has data in 52 rows (starting at row 2) and 4 columns (A, B, C, and D). Currently column A is unique to itself, and Columns B, C, D go together. Excluding headers, each column has the following number of cells with data: Column A has 52 cells Column B has 40...

I want to fill a column with all of 2013's dates but those falling on Sundays. how would I do that? Thank you.

I have an excel file with 1st column having Sr. Nos. Sr. No. Group Name 1 A Anand 1 C Bismillah 2 A Chintan 1 B D'Souza 2 B England 3 C Foolandevi 3 B Gavaskar 4 C Hindmata 4 B Icecream 3 A Iceland 4 A Jamunadas Note how Serial Nos. are given. This is to accomplish getting correct Sr. Nos when...

Hi guys, I had so much help from others here with the last macro and I am hoping someone can help me out with this new one. What I need this code to do is copy the value in cell B4 in one workbook to cell G6 in the other workbook, and continue copying the value down to the last row. The...