record

Hello everybody. I have a folder that contains many workbooks. I need, for any workbook: 1) check if is a .xlsm workbook; 2) if yes, check if a sheet named "Record" exists; 3) if exists, import stuff from sheet "Record" to thisworkbook. How can I identify the required workbooks (points 1 and...

Hello, I have the code below set up within a command button. I need to move the record to another tableand then delete it from the current table. I am able to get the code below towork one piece at a time, but it’s not working combined into a click of thebutton. I am getting the error message...

I have a macro that works with a large spreadsheet (12,000+ rows) It is a daily spreadsheet I update with previous day data. The macro pastes the updated info to the bottom of the existing data. Then the macro does a FIND of the record # in column A to locate that corresponding record in...

Hello, I am attempting to use an append query to move one record from onetable to another. I am using the below SQL code, but when I run it I get amessage stating that 2 rows will be appended, but I only want to append thecurrent record that is being viewed on a form. FYI - The tables being...

Hello, I have thousands of records that came out with really crappy formatting. BESBAN Best Banner Sign LAURA TUCKER Yes LAURA TUCKER-2 Yes ROCHELLE BROGLER Yes ROCHELLE BROGLER-2 Yes BESEEN BeSeen Today.Com BESNEO...

I have a table that has records within excel. The record has a date in the format dd/mm/yyyy. The table will be used as a data entry form with the record being copied and pasted into the relevant tab for the month. The name of the worksheets are July2018, August2018 etc. I have added columns to...

I am new so sorry if this does not sound tech enough, I am not a professional in anyway and I could use some help from some of you that obviously brilliant at this.... I have a simple table that tracks incoming documents from a client to start a clock for response. I have a form that my...

I've done it before. Its not f9 (which shows the calclatations in parts of a formula). Besides, f9 is not working for me right now. Its something else which is quite simple. But havn't (though should and could have) used all this time. I did it once for a concatonate. Now want to do it for...

Hello everybody. I'm dealing with a closed csv file called "record". It I open it manually, it seems a pure xls file (there is one only sheet with a series of data organized in rows and columns). I need to copy the data to thisworkbook (which obviously is a .xlsm). But something gets wrong...

Hi, I have a form to add new employees (LastName and FirstName with new unseen EmployeeID) to Employees table. I have a save (it saves the record and goto NewRecord) and cancel button RunMenuCommand Command UndoRecord, which basically delete what is typed in both fields of the...

Hello everybody. I've set a dropdown list as follows: https://imgur.com/a/ntDkIK9 Dim MyListB(2) As String MyListB(0) = "YES" MyListB(1) = "NO" Dim lrut2 As Long lrut2 = Cells(Rows.Count, "A").End(xlUp).Row With Range("B2:B" & lrut2).Validation .Delete .Add Type:=xlValidateList...

Igrateful for any help here – way out of my depth. I have spreadsheet which has dependant drop downs using the indirect function. However,on the same sheet I need to record the 10 most often recorded entries in columnD Is thispossible?

I'm using this array formula to find the latest date in a range; In cases where there is no date found I am getting "00/01/1900" - can this be taken out by the formula so I get something like "NO RECORD"?

hi all i have sheet witch contain data and i fill data on it then it's calculate , finally i close it and go to word document witch already have letter mail merge , then i print some of it , maybe record #1 , maybe from record 1 to 50. i want to use macro to run it from excel to 1.run mail...

hello i wonder if any of you could help me i need a formula in a cell that can "remember" or "keep a record" and sum the values that changes in other cell example <tbody> 1 1 </tbody> then <tbody> 2 3 </tbody> then <tbody> 0 3...

I imported some data from a SQL database. However, one field has multiple values. Each record is a row but in the field with multiple values, a 2nd row was created with only that value (column K). I would like to move data from K to the corresponding row above it in Column L, M, or N as...

by using data validation we can lookup from a list and select a record. my query is how can we delete that chosen record from the list as soon as it is selected? it's like a cut and copy paste process but only it is in a drop down list via data validation. hope this is clear. many thanks

Hi, I am trying to set up ledgers for my business and I would like to pull amounts to the respective sheet if I use particular words. For eg. if I record CASH on the SALES LEDGER it pulls the data to the CASH LEDGER and if I record DEBTORS on the SALES LEDGER it pulls to the DEBTORS LEDGER...

Hello, I was wondering if it is possible to create a macro to paste record from a form (Student ID, using Student ID Table), into a different table (main_data) and delete record? If so, how is this possible? Thank you