past

This may sound like a totally n00b question, but I searched and didn't find anything about it, so here goes: I have a list of 51 names in a Word (2003) document and I need to transfer them to a column in Excel (also 2003). I'd rather not have to do it one name at a time (as I have in the past...

Is there a way to create conditional formatting for past dates? I'm trying to make the cell green if it's a date in the past 15 days (to today), yellow if it's 15 - 30 days old, and red if it's 31 or more days old. Any help is greatly appreciated. Than you

My hard drive crashed in work laptop crashed la week, so IT had to replace it and re-configure/re-download everything on my laptop. The one thing that is still driving me bonkers is when I copy from one workbook to another, I randomly get 2 different paste options (boxes below). I didn't get...

Hi, I am getting the error "overflow", when I assign a variable of type double a number >32,000. What is going on? dim guess as double guess = 73000 'no overflow error guess = 73 * 1000 'gets an overflow error I remember this error happening in the past.

Hi all okay - hoping you can help with some VBA here... at the top of 52 columns I have the date of the first day in each week - as per attached screenshot; I want to group all past date columns together and all future date columns. Obviously I can do this manually, but I'd like to automate it...

When entering a date, how do I display a message box that asks for confirmation to continue if the date is in the past?

HI I have a workbook with several sheets with same layout but different data, How can I copy data from all sheets into 1, the amout of data varies so would need to past all data into next empty row. I have this code Sub SummurizeSheets() Dim ws As Worksheet...

Hi all, I am trying to find a way to extract duplicate data from one table where each value has multiple rows and get it into a table where each value has only one row. So in Table A, I have the following columns: employee name, holiday booking date, future booking?, past booking?, sum of...

I have below text file which I want to convert in excel. But the issue is all the data is not properly aligned. Can someone assist Account Receivable Date: 30-JUN-2018 18:08...

ok so ive been using VBA excel for college work and we need to add a date picker tool to select a date however we need to validate it so that they cant select past dates this is what ive tried but its came up error can anyone help? If DTPicker1 = < date then MsgBox "You can not select a...

The title really doesn't explain what is going on, I am writing a story and I use Excel for keeping track of the timeline What I am trying to do is show how much time has past between the dates in the same chapter, but I also want to see the dates in chronological order. Some dates get...

I am trying to sum the total quantity of orders, between 6 part numbers, over the past 90 days. I have come up with a 90 day sumif for a full column =SUMIFS(C6:C20,A6:A20,">="&A2,A6:A20,"<="&A1) A1 =now A2 =now(-90) A6:20 = Date C6:20 = Value It works great for a table with only 1 type of...

My report contains data for employees working on projects for each pay period for the past several years. I need to sum the labor hours (column M) for each employee (column H) on each project (column I) for each year (column S). I need the total on the first row. I've used countif/sumif...

Good morning eveyone, I have sheet1 where I past information from SAP. In a second tab and for each line in sheet1 I have to copy past the info on 6 lines What I did is cell A1 of sheet 2 is "=sheet1!A1" cell A2 to A6 "=A1", ="A2" etc.. Problem is, I have about 500 lines in sheet one, and when...

I am at a loss...I cant find anything online to help figure out why I am getting this error message. I have used this VBA code before (located below) and now when I try to use I keep getting this error and cant move forward. The website opens and I can sign in but the coding is supposed to...

Hi! I would like to find past and nearest date with parameter "X" for a given date. Sorry for my English :).

Can AVERAGEIFS work the way SUMIFS works in this example? (SUMIFS example works) =SUM(SUMIFS('PAST YEAR'!F:F,'PAST YEAR'!D:D,NJIL!A:A,'PAST YEAR'!A:A,{"IL","1"}))) =SUM(AVERAGEIFS('PAST YEAR'!F:I,'PAST YEAR'!D:D,NJIL!A:A,'PAST YEAR'!A:A,{"IL","1"})))

Hi Everyone, I have a calendar or list of dates in sheet Cal row 10 range M10:AYX10 each cell has a date in it from M10 = 01/Jan/2018 on now what id like to do is hide the Months that have past So when the workbook opens it takes todays date, looks along Row 10 finds the date and Hides all...

Hi All, Could do with some assistance in improving the view of a comparison chart for data similar to below <colgroup><col span="2"><col><col><col></colgroup><tbody> Prog Week past fixed point open closed Prog 1 13 1 6 3 15 2 5 2 Prog 2 13 3 4 1 15 4 3 4 Prog 3 13 5 2 5 15 6...

Hi All, Kindly help on the below I have excel sheet which update the daily productivity of the different user for different process in a same sheet. What happens is the user update the daily productivity, sometimes they add extra volume or change the productivity details which is in the past...