information

Hi, Can someone please help me with this: I have a database with the fallowing information for 200 employees: Employee Name, ID, Department, Position title, Performance rating, Base salary, Performance rating,%increase, Previous year salary . I need to create a tab for each employee with...

Hello everybody. I've the following directory in my pc: R:\Users\john.smith\Downloads It contains two files, only one of them is a .csv. But, about it, I don't know the exact name. How can I open it exploiting the only information I have? (it is a .csv file). Thank's.

I've stripped out all the path information and identifiable information. This is referencing an external workbook, but I have never seen an index match written like this before. Could someone please explain what this is doing...

I don't know if this is possible but here it is: I have a sheet that I use to display an overview of competitors. The information on the sheet shows one competitor at a time based off of a data validation dropdown list of values. When the dropdown list is changed, the cells on the sheet change...

I have a excel vehicle tracking system that uses log sheets entered by trip that has a date associated with each entry. This includes kilometers driven for that date and for what vehicle. I have the ability to change the year and month on a report tab that will produce the kilometers per vehicle...

Good Morning, I have two spreadsheets: 1. Is a master file of 10,000 cutomers that contains all information such as name, ID, address, payment schedule, price charged, item brought 2. Is a file that has some information in, but has lots of missing data. I want to use file 1 to populate file 2...

I am unsure of how to explain this but I will do my best! I currently utilize a module that can count and sum based on the color of a cell or the font. It works wonders https://www.ablebits.com/office-addins-blog/2013/12/12/count-sum-by-color-excel/comment-page-2/. Whenever that information is...

Hello, I am building a customer login sheet/tracker. I have a tablet that I will be running the login sheet off of for the customer's to fill in their information and I have put a shape at the bottom that looks like a button. I want to add a macro to where when they click the button, it copies...

Hi, any help would be greatly appreciated. I have worksheet with multiple columns of information in it with my M column containing a lot of information at once. The information in column M always begins with "Door Surf Color:" followed by a 4-6 letter word. I want a function that will lookup...

I have a macro which works perfectly for one search and will display the information correctly. This macro is then cycled by another macro to view other matches for the same sort information which works correctly. Problem is after (about 20 or more) cycles, the total program goes belly up and...

Hi, I have a column with data that contains campaign id, content id and name id. I would like to have a macro which will paste only the campaign ID in the column next to the information below, which macro can I use to do so?: <colgroup><col><col></colgroup><tbody> Data Campaign ID...

Hello! looking for some help. I have a sheet with over 2000 rows, some duplicates, some not. I am after a way to quickly edit the sheet to achieve a few things: 1 row entry for each unique item - combine the information (If info is present) in columns E, F, G & H for the row. Here is what I...

I am working on converting an excel Master Sheet into a userform. I didn't create the Excel Workbook, which has about 16 worksheet in it, but I have to update it. Most of the information in each of the 15 or so worksheets are repetitive information, that is why the person created a Master...

Good day, Building out a project plan trying to pull in predecessor dates to the successor. I wrote a formula to count the "." in the task #. I wanted to pull the max end date of the successors of the predecessors. So for 1.9's end date would like to receive the end date for 1.9.1. The issue I...

Evening all, I hope you can help. I am trying to enter details for a region of South England, United Kingdom and pull this information in to a map using Excel Maps. However I can only get the map to show England, Scotland, etc and not the counties. I am trying to add A1 - Reading A2 - Swindon...

HI i am new here my name is Christy, I joined this site because i am having trouble with a particular VBA code I want to take information from cells in work sheet2 and put it into work sheet1 last row which already has 1865 rows full of information The Range from sheet1 is B1-B9, (which is a...

Hello, I have a list of information in a column that I want to concatenate into a single cell. I need a line break between each line of information but the problem that I have is that as I don't know how much information will be entered into the column each time. I have allowed for possible...

I have a table with 4 columns and information in each column can repeat where: Column 1 is "NAMES" Column 2 is "Start date" Column 3 is "End date" Column 4 is "Description" I initially used the built in sort and kept replying to handle this but after a while it became troublesome as there is a...

Looking for advice and help. I have a user form that can enter, search, edit and delete information that I need to expand on. Currently all the information is stored in 1 sheet, "Data". Which is the source and copy location for a filter for the "master data" (if you will). For example, if I...

Hi all, So I've started working with VBA a bit and have figured out what I'd like to do and that it is possible, I'm just not skilled enough to be able to write it from scratch. I've always found it easier for me to work with existing code and learn what everything does by modifying parts of it...