information

I have a large number of RTF documents that I am opening using Access. I would like to reformat the document and then copy them into a control. I am able to open the documents, and go though all the paragraphs in the document (using the paragraphs object). I found that my macro's are missing...

Hello I am a VBA novice but have been having a crack at the following problem but I need more expert input and assistance. The problem is to extract information from control content field into tables and "related" and copying the information to a single row in excecl. I am having difficulty...

This isn't an "how do I do something" post (yet), but an "is it possible" post. I don't want to invest a lot of time and effort into trying to create something if it isn't possible, so I haven't even started creating a database yet. My background with MS Access is as a user, not a creator, so I...

Hi from Canada! I found some very helpful formulas thus far to help simplify a very data-filled admin job. I can not seem to figure out how to get the information that I want presented and hope that someone can help. I am not as fluent in Excel as I wish to be... I have a list of close to...

Hello there, I have the following issue: I have a report sheet in an excel file that combines the information from several template worksheets in the same workbook. I already got the idea how to create a template worksheet every time i hit the "+" button. What i now need is to enable a formula...

I have found so much information thru this forum and learned from you all! I am quite a novice with VBA but find it fascinating! Thank you so much in advance for your help. Background: My current project is to update and streamline parking lot vehicle information for the school I work at...

Hey I need to create a user form but I need to have a table in it that the user can paste unlimited rows and 3 columns into from another excel document. How do I go about doing this? Each user will have the information they want to copy onto the userform in different places, and it will...

Hello all, I got 2 userforms; Productionreturns and QA returns. Both contain the same labels; lblGelcodeR and lblProductnameR. Both contain the label info; if you click on it a new form opens: Information The form Information contains the label lblGelCodeR and lblProductnameR. They should...

Hi to all I am learning VBA and I need you help: I am trying to copy the information from Data Tab to Table tab, but I need to put all the rows for the material in only one row (like transpose). Just only with one condition: the data with information "Not short" in column L is not considered...

I am looking for a solution to allow me to quickly retrieve information from a reference list within excel. Lets say I have 4 lists of information for events. These located in columns AF, AM, BF and BM On the working area, I have 4 cells. Cell 1 = user types "A" or "B" (Event classification...

Hello, I have a new project to work on, and I am trying to find the best approach to get this done. In short, I have files summarizing business with our customers (about 400 of them). The format is not perfect, but I can probably work with it (columns are always the same, but information is...

I have done some research and I have not been able to track down any information on the following. Can anyone offer any advise/direction? I want to provide a cell with drop down options that are base on the information entered in another cell. Is this possible in excel 2016 ? Thanks in advance!

Hi everyone! I'm looking for an option to reduce time and mistakes. Daily I have to do payment batch. I get the information through a web page, so I copy it everyday to a excel workbook and filter the information and copy 1 by 1. As a batch it has pre-charged and fixed information, so I need...

Hi, Here's my code.. Range(ActiveCell, ActiveCell.Offset(0, 2000)).Copy Destination:=Worksheets("Deleted Runs") _ .Range("D2") I'm trying to get the row of information to copy to the very NEXT row down on the other WS, "Deleted Runs". I have a code around this that take the offset of...

Hi All, Probably simple I just cant figure it out how to do it, could someone please help me I have column with filenames containing revision, status and format. I would like to extract all information except the file format. An example as below: 12345_ab.A.IFI.pdf 2432423.B.IFI.xlsm I...

I have a worksheet with several 000's rows of data, holding information about patients' visits. Each row holds the information of a single visit. Each patient can have multiple visits (i.e. appear in multiple rows). The table is sorted by patient name, and the left-most column holds the patient...

Hello Everyone, I have 5 tabs in total in my workbook, when I click on the macro button I want to clear the information from the dashboard and then bring in the information from the other tabs onto the Dashboard tab. So the problem i'm having is when I bring in the information from the second...

I have the property set to, "Match Required" for my comboboxes. I have a clear button that resets all of the values of my comboboxes to nothing, "". It keeps saying the selection is invalid after the clear button is pressed. I'll then fill out the form with the correct information and I'll...

Hi, Only when sorting numbers in ascending or descending order all row information get's messed up and disconnected from where it actually belongs. Due to this wrong data is presented under all project numbers. When clearing the filter, it does not return to the correct project number. I have...

Hi, I have a simple Excel-sheet with some data from an SQL-export. Row B contains information on your typical age-intervals (0 - 9, 10 - 19, 20 - 29, 30 - 39....). The intervals are formatted as text. Unfortunately, Excel automatically converts the interval "10 - 19" to a date, Oct-19. 0 -...