record

I have Excel 2013. I go to to a workbook. Click on developer tab. I click record macro and store macro in personal macro workbook. A popup says personal macro workbook in the startup folder must stay open for recording. i click ok. Another popup says unable to record. click ok and close the book...

I have two workbook with D column having unique number. How can we remove the duplicate in 2nd file based on 1st file data? Vlookup cannot work, as when i do Vlook up it picks up the data of 1st record as well on the 2nd record which should be the 2nd vlook up data.

I'm new here. I am wondering if anyone knows how to add and option in a column to add another column. For example, I want to record what chemicals I am applying, and since sometimes there may be up to 7 chemicals at a time, I want the option to record each one, or if there are fewer (obviously...

Is it possible to compare two records from the same table? For example: I have a database with a table called STEP1. The table contain columns: STEP1_ID, Amount1, Amount2, Date If my record have the values like this: ID=1, Amount1 = 500, Amount2 = 300, Date = 2019-03-01 Now i want to compare...

Hi All, Wanted to know if anyone can help me with the following VBA for a pivot table, which is not working... With ActiveSheet.PivotTables("PivotTable1").PivotFields("ACCT_DESC").Subtotals .Font.Bold = True End With I'm trying to avoid using ".PivotSelect", which is what you get when...

Hello We have a one field continuous form that we use to scan numbers into. The problem is after each barcode is scanned the user must hit tab , enter or use the mouse to navigate to the next record. Is there a way to have it move automatically ready to receive the next scan with the user...

Hello All I'm trying to alphabetize an array. The list is columns B through K with columns G and H merged (which is causing my problem...) and the whole thing starts on row 3 and goes down to row 52. Anyone know any vba to get around this. I was trying to get excel to record my sorting so I...

I am trying to sort through a file that comes in a bunch of strings. I am hoping to do the following. Take a value in the Client sheet (Client name) in A2 and filter the results in the Data sheet (trying to find the client name in the string) Each record takes up 4 lines so I want to copy...

I have a print problem with a macro. I am printing a label so my temporary sheet needs to have a print area defined and I am trying to define B1:C10 of a sheet but I keep getting each column defining itself as a page. I can record it but it will not allow me to use that language in the code. It...

I have followed several links here and elsewhere and just can't figure out what I am doing wrong! I select items from a listbox display and then wish to update (2 lines for my testing). The first iteration appears to go through all steps when in debug mode BUT does not actually update the...

I'm not an advanced excel user, and there is probably a very simple formula for this, but I am wondering if there's a way to record the value of a cell at a certain time. I'm a writer and I track my word count progress (cell C11) for each hour of the day. Right now, I'm putting it in manually...

Dear Sir, I have copied some code from your site. And now I want to change little bit thing in code. Sub DoMailMerge() 'Nodte: A VBA Reference to the Word Object Model is required, via Tools|References Dim wdApp As New Word.Application, wdDoc As Word.Document Dim strWorkbookName As String...

I'm attempting to create a macro that formats a worksheet of raw data. The macro is deleting unneeded columns, wrapping text, selecting page size and margins for printing etc. There are no formulas in this data. Once I record the macro and go back to test it, it formats the columns and page...

Hello, newbie here. I wonder if it's possible to create a macro which creates hyperlinks for all existing values in a column such that: 1. When user clicks a cell link, a Google search result page opens, showing results based on existing cell string value 2. Tooltip of each hyperlink shows...

Hi Community, I have a VBA macro for a log record that copies information from a submission form and pastes it in a Log Record data file based on a IF condition. THe condition is partially working where if the condition is true then the data is copied to the log record, But when i try and...

Hi experts i have a query please anybody can solve it.. <tbody> ID Name Amount Descp Search ID here >> 1004 1001 ABC 500 On Cash ID #N/A 1002 XYZ 1000 Credit Name #N/A 1003 ZYW 1000 On Cash Amount #N/A Descp #N/A </tbody> In blue words is Sheet1 which is a form in...

Hi there, I have a sheet which is full of data. Within the sheet, there is a particular range with data (D10:J29) - 20 rows There are 10 records in this range, 2 rows for each record. These records are entered via a userform and should start at D10 and then the second record would be recorded...

Hi Everyone, I'm an absolute novice at best with Access but am trying to learn. I am running the code below on a button in a filtered form. What I would like to do is run it after my last field is entered IN THE FIRST RECORD and I press the ENTER key creating a new record. In addition in the...

Hello guys i want to get only 1 record from a duplicated records because i have many duplicated dates i just need the oldest record, the formula im using is computing all the training hours for the whole month. Can someone help me with my formula Thanks!! =SUMPRODUCT((MONTH('ABN...

I have a report I run daily and wanted a macro to use on the formatting of that report. There are numbers that show up as text and if I click convert to numbers it does not record in the macro. So I tried the keyboard shortcut ALT+Menu+C and that did not work either. Any ideas on how to get...