tab

Hi All, Wondering if someone could point me in the right direction and help please - I have a workbook that I generate other workbooks from, so from the dataset in the main tab a macro sorts the data and then for each name, generates another tab with all the respective data on. For example...

Hello! I’ve checked similar threads for the answer to the following, however I’m either not clearly seeing the answer in one of them, or it just doesn’t exist yet. First off, I know next to nothing when it comes to VBA and UDF. If I did, I likely wouldn’t be here. ;) I have what can...

I have a code to fill in multiple PDF files from data in an excel sheet. It gets data from the first row and fills in the pdf and saves it. Then I need it to go to each line and fill in a new pdf and save it. When it creates the first pdf and saves it, a preview of the pdf comes up. Then the...

Hello everyone, This is my first time posting just as an FYI. I am trying to make a cross tab query that shows Location as the rows and Week Number as the Columns with a value set up in builder. Where I'm running into an issue is that in order to get the accurate value, I need the distinct...

Hello! I will start by saying that I don't really know anything about coding or VBA...other than copying the help all of you have given me in the past to a new module and connecting that to a button. So! I'm hoping someone here will find this ridiculously simple and be able to help me. I have...

hi all. I have a userform in which people can select trips/events from a multi select listbox. The list box's row source is a named range containing the name of all trips. each trip has its own tab. The tab names are an abbreviated version of the trip name. I need to have the details of the user...

Hello, I've got a problem with a couple formulas I've entered on a spreadsheet. The first formula is performing a calculation based on data from another tab. I want it to round the results to the nearest whole number. I can click "Decrease Decimal" and it shows 1.9 as 2 for example. The...

Hello! I am trying to create code that once a user click on the tab “LeadershipSoftwareOverview” the sheet will be unprotected, the pivot table on that tab (labeled “ResourceSummary”) refreshed and then the sheet reprotected. Below is what I have and it is not working. TIA!! Private Sub...

I'm trying to create a look-up formula that fills in cell values in accordance with corresponding variables from different tabs. For example: In the tab "Match-Up", cell "J3", I'd like the formula to display the number of games "Auburn" has played (according to the data found in tab "Auburn")...

Hello All! I was attempting to have a tab hidden based upon 'yes' or 'no' value placed into the cell of another tab. I have included my macro below (see very end for my issue) which is not working. :( Any recommendations appreciated! Thanks! Private Sub Worksheet_Change(ByVal Target As...

Hi I have a workbook that has data in columns A-E. Depending on what data it is in column "A" is has the word "ABC" or "TAB" and then columns B-E all the specific data. What im trying to do is if poss via a macro look all the way down the workbook for entries in "ABC" and "TAB". The...

I'll start off with I haven't done VBA coding in a while. This is what I am trying to do. I have a column with tab names, and I have a column with file names that I want created. I'll give an example: <tbody> Tab Name File Name Bananas_For_Sale Bananas.sal Apples_For_Sale_No...

Hello, I have the VBA code below. End goal is to have each tab in the workbook to be exported into its own PDF. Problem: it works fine on my computer, but when someone else tries to use the macro on their own computer, it errors. Sub ExportToPDFs() ' Save Each Worksheet to a separate PDF file...

Hello, looking for some help. I have a raw data tab which contains a large data set which can be grouped into 5 categories based on the attribute in column 'BB'. I have 5 tabs which I would like to look up the value in column BB and if it is a match then pull into the tab. Preferably I would...

Hello Excel Guru's, I need your help on how to do this in Excel 2013. I have 2 tabs, 1 for details (source data) and 1 for my summary (target). In the summary tab, I need to mark the Name of the animal with X if in the Remarks column the cell value is blank based on the latest End date. Hope...

hi all, i am looking to match two separate criteria listed on tab 1 to a table of rates on tab 2. i would like to find the rate and then multiply by another number back on tab 1. hopefully that makes sense. i assume an index, match would work, but not sure how to take advantage of 2 criteria...

Hello all, When I am trying to print, the pages contains too much white space and doesn't take up the entire page or have my data too small. Please advise what I can do. For the first tab, I am trying to print the data onto 3 pages(portrait) but there is too much white space. How can I have...

I have a multiple tab worksheet. I want to be able to: (1) Search a particular tab based on an input (2) Within that tab, search for Row heading and a Column heading. For example, I have several tabs, however I want to search the "Colorado" tab, and want to return the result for "Aurora" [where...

In previous versions of Excel I was able to tab into the chart formatting menu that popped up and use the alt keys to jump to the functions with underlined letters. Now when the menu pops up along the side of excel I haven't figured out how to tab into it or use those same shortcuts. Is there...

I need to put a pivot table/chart together for data that is in 4 tabs of my excel spreadsheet, however I haven't figured out how to do so. I can do it for each tab individually no problem. any help would be appreciated. Thanks.