Search results for query: *

Hi, I found the below code in one of the threads and was wondering if can be amended to handle the following: I have two sheets I want to compare and spit out discrepancies in another sheet (called discrepancies). The Id will be common each sheet. I want to compare amt, order and price (see...

Hi, I've seen code to delete duplicates. I can modify the code to copy the duplicate cell into another sheet, but how can I copy both duplicate cells and copy both rows into another sheet. I basically want to track duplicate records. Your help will be greatly appreciated.....

Below code takes 45 minutes to process 28,0000 rows. I'm using a SUMIF to grab data from another tab with predetermined ranges. This is my second post and need your help. I never encountered this type of problem before. Please Assist!! Sub BBGDownLoad12() Dim lastcell As Long...

I have a great deal of data that I pull in daily. It can range from 200 rows to 35000 rows. The below code works great if the date is not greater than 2000 rows. Can anyone suggest how to improve the efficiency of the code to handle large amounts of rows?? Also, It needs to be done in...

I have no clue on how to do this. I don't want to use Data Validation tool in Excel. I basically want to run a macro to read thru a range of cells and paste in another sheet the Unique IDs??? I found a function on line that counts unique ids, but I can't figure out how to use the code in a...

Hi , I have a main user form and based on input dates and combo box selections the below code will open up a query. My problem is if no one inputs a date the code should tekll ya to input a date...This only works when you first open the form..i suspect the code is not written that well and my...

Hi, I'm creating a new db and did Tools -> Options -> Advance -> and selected the default option to Shared instead of exclusive. My problem is this is not working. If one user has the db open and other user trys to open the db they get an error message. How can I get multiple users access...

Hi All, I'm trying to get the TimeStamp of Files I'm importing into my Table tblFileNames...In the table I have the path and File name in the third column I want to know the Time Stamp of each file. I tried the below function, but I keep getting an error message...I would appreciate your help...

Hi All, Got an issue with SQL statement. My problem is I import a text file 4 times a day (data is always updated). The first import may contain 20 lines the next 50 always growing. To avoid double counting (since the import always has the previous data) I tried to use the below SQL...

Hi All, Got an issue with SQL statement. My problem is I import a text file 4 times a day (data is always updated). The first import may contain 20 lines the next 50 always growing. To avoid double counting (since the import always has the previous data) I tried to use the below SQL...

Hi All, I have a spreadsheet were I copy data from A1:AD500 and paste it in another spreadsheet. My problem - I want to paste the data but have a row in between each line. Basically I have to insert a blank row in between each data row. Is this possible??? For example - 100 200 300

Hi All, I'm trying to print multiple ranges into one pdf document. I'm having a difficult time trying to do this because the ranges are in diffrent sheets in the same workbook. I would appreciate any feed back. I;ve attacted a sample of the code I'm working one. Sub MyPDFRangePrint() Dim...

Hi All, Does anyone know how to determine the last Business Day of the Month (including Leap Years) and the First Business Day of the month??? Basically, If I I was in January 04...I would like to determine the last business day of that month and the first business day of Feb 04..I don't care...

Hi All, I have a wksheet that contains 8000 rows. Data in Column A contains Dates. I currently sort the data and have a another spreadsheet do a bunch of sumif's of the data for a paticular date (today -1). My problem is the one day there may be 50 (today -1) and the next 2000 (today-1). So...

Hi All The below code creates stacked column chart. Is it possible to seperate the Series 3 and Series 4 in a seperate stacked column in the same chart. Is it possible - Sub Macro2() Charts.Add ActiveChart.ApplyCustomType ChartType:=xlUserDefined TypeName:= _ "Julia...

Hi All, Sorry for the long desc - I have two ranges I want to compare. Range one is in Sheet1 and range two is in Sheet2. Both ranges share the same ID number(the ID numbers are not in the same order in in the worksheets and I can't sort them, because it will effect other data in the...

Hi All, Sorry for the long desc - I have two ranges I want to compare. Range one is in Sheet1 and range two is in Sheet2. Both ranges share the same ID number(the ID numbers are not in the same order in in the worksheets and I can't sort them, because it will effect other data in the...

Hi All, I want to compare two string values in two different worksheets. Each string value has four other values I want to compare based on the string value. If I do not match on any of values of the string then I want the results (mismatching strings and the values) to be printed out on...

Hi All, I want to compare two string values in two different worksheets. Each string value has four other values I want to compare based on the string value. If I do not match on any of values of the string then I want the results (mismatching strings and the values) to be printed out on...

Hi All, I have a code that works pretty good, but if a user enters a date in the input box that does not match the data I'm filtering it keeps looping. I tried IsEmpty, but with no luck. If the data that is being filtered is outside my date range and the filter is Null. My macro keeps...