help me please!

Hi, I have created an excel which has Multiple Data of Multiple Persons of different days in a Pivot table and I am getting this data one by one on a pivot table by clicking on a Slicer which has a Person name( Person name I made as an identifier in the datasheet ) and then data comes of all...

Hello, If someone could help me, it can be vba or just formula in excel. My dilema is to make a scheduling calendar that tracks the frequency of lab test. For example, normally test should be done every three days, which will be recorded in the calendar. However, if for 20 days, the tests seems...

I am currently in the process of self teaching myself how to create a multi-tab user form to help with data entry in a multi-sheet work book. I have created the user form but am struggling with the code portion of things. I have created the simple code for the cancel button to unload, and...

I have a huge project, and I am looking for some assistance. I usually do single entries for Mail Merge, meaning one letter is one row of information, easy peasy. The current project I need to merge is not one row every single instance. I have a list of patients, sometimes the list is one...

hi all,i am so sorry if i ask repetitious question but i can not find any related by my problem,however I have one Excel sheet, one userform and a listbox is in userform. Now when i filter my sheet and update listbox by click on button that is on my user form i see all rows in list box. I mean...

i have 3 rows of words only 1 column in each row has a word and i want to make them all on the same line and get rid of the # vaule...the problem is that the "empty" spots have a formula in them so they are not technically blank -- removed inline image ---

Please help! I am so stuck!! I need to format several columns and rows with the following rules but I can't get all cells in my selection to change colour. For some reason only Q5 is changing to red Also, I need to automatically duplicate this formatting on other rows without having to...

Hi everyone, I'm new to this website and forum but I am having a lot of trouble with a function in excel and I thought I would ask here to see if it is even possible. I'm trying to create a workbook for my boss and he wants a list of all of our customers in the first sheet. However he wants...

Hello. I've got a cell that gives me the name of a worksheet that I need to use. In that cell it can appear 6 different worksheets, and I want to the cell next to that create a hyperlink to the worksheet that is given in the first cell. This is: cell A2: worksheet1...

Hi all, I haven't been using VBA for very long and am on a steep learning curve. I've seen a lot of code that comes close to doing what I want, but having problems writing a macro to do my specific task. I apologize in advance for the amount of information. If anyone can help with code for any...

Hello! I need help. I'm reletively new to Excel and trying to get a handle on Macros. After relentless internet searches, I still cannot find clear instructions on how to solve my issue. Goal: to have a Macro that I can use in any workbook. Problem 1: currently, I am not able to record...

I would like F3 to equal E3-D3, if there is a number OR formula in E3. If there isn't anything in E3, then it would look to see if there is anything in D3. If there is, then D3-C3. If not, then see if there is anything in C3. If there is, then C3-B3. If not, then = B2. Is that possible? Thank...

Hey there, I am trying to understand how to create a formula that would pull what I currently have in the Input Cells automatically when I update the other spreadsheets. The cells will change as I update, but I still want it to give me the sum for what I am asking for. For instance, on the...

I'm having trouble getting index match to work properly if the row are out of order when I'm pulling data from sheet to another. what am I doing wrong? <colgroup><col style="width: 48pt;" span="4" width="64"> <tbody> Items YTD Items YTD A 1 A 1 B 2...

Hi I am trying to create a worksheet to keep track of good and bad things that are happening to certain employees. Here is a test sheet that I put together just need it to be able to actually work. What I want is when I check the employees in the list and press the button labeled good it adds...