tab

Is it possible to create a list using data of a different tab using an IF(AND formula? I have 3 tabs. My first tab (Firers) has 4 columns (Rank, Name, Date, Iteration) My 2nd (27SEP) and 3rd (28SEP) tabs have 3 tables each (Iteration 1, Iteration 2, Iteration 3) Basically I'm looking for a way...

HiI have a list and I have just added a new name to the list. I now go to my main entry sheet and when I go to column F and click the down arrow it appears, so far so good.My question is, is there a way of automatically creating a new tab at the bottom with the new name?RegardsStephen

Hi I'm creating an Excel workbook that contains edited info from another (to send to a third party, so hiding is not an option) Both are made up of numerous tabs. My current formula is: ='[Z CONFIDENTIAL MASTER EQUIPMENT LIST.xls]B2 01'!C10 Is there a way to replace the bold tab name in the...

Hi, I'm pretty new to VBA, and was hoping someone might be able to help me with something i am trying to write: Sheet 1 (input tab): Row 1 contains Mon-Fri, with the rows below detailing what car parking spaces are available for those days, for example, if space 18 is available on monday...

Hi. I have created a new ribbon using the editor and have created about 60 new tabs. Well as you imagine having all these tabs are a bit of nightmare scrolling along to find the tab i want. Does anyone know if there is a way of using a macro to search for a particular tab, maybe a combobox...

Hi, I have multiple workbooks and would like to check that what the scaling is on each of the tabs before I print it out. Maybe some script that gives me a report tab maybe. Thanks Rich

I created a workbook 3 years ago and since then each month I have been adding a new tab. I currently have about 36 tabs. All tabs are identical size which they are from A1 to AP69. Not every cell has data but most of cells has something in it so I don't think it is necessarily a big file. Every...

Slightly complex and due to restraints i only have Excel to play with. I Want something like this: Tab 1: Data of jobs to be done Tab 2: All staff with how many minutes they work per day Tab 3: All product families we build and how long a batch will take to build in minutes then how many...

I'm building a fairly complicated spreadsheet that is going to be updated weekly. The spreadsheets name changes monthly so building a macro wouldn't be user friendly and I'm trying to build formulas with the workbook. The user imports data from another spreadsheet into "Week1". From there...

Hi, I have a list of value in tab "List" A2:A## I want to update the tab "summary" "A1" with each value from the list which updates the summary Tab with data. I then want to copy this print area from the tab "summary" to a new workbook until every value in the Tab "List" is used. I then...

H All, I’ve broken my brain on excel and need assistance….. I’ve built a doc to help me calculate the number of staff working by 15 minute interval per day of the week. I have around 50 staff but they all work different days & hours in the day. I seem to be having issues at certain times of...

I have a userform with a bunch of text boxes, and on the bottom a Submit and Cancel Button. I want to be able to tab through these, but because the Cancel button is the last in the TabIndex, if a user is holding Shift and presses tab, it will go "backwards" to select the cancel button. Is there...

Hello, I have a large data set in tab 1 and in column T there are statuses (Active or Retired). what I would like to do is create a new tab (tab 2) to only show those individuals with an Active status. So every time I change the status to Active in my first tab it would populate into my new tab...

Hi I have a spreadsheet running vba which separates data into the relevant tabs. my problem is after running the macro, if i need to correct a line in the master sheet it doesnt update or create a new tab. So for instance, tab 2 has 2 lines of info, i then go to the master sheet and edit 1...

Hi, I have not used VBA in months and my first task back is trying to create a menu page which will have a data validation drop down with multiple selections on there which I want to link too certain sheets. So when selecting "test" from the drop down list then it will take me to the "test"...

Hey there I am creating a template which has a variables set up page. On that page I want to provide the user the ability to enter values into cells which generate tab names. There is a finite number of tabs - so want to have a direct link between a cell reference and a specific tab name...

Hello, I'm a new VBA user and really need some help. I'm trying to perform pairwise permutations of an undetermined number of values entered along a single row. The permutations should be exported into columns A and B in another tab. Then I want to repeat this process for the next and all...

Hi, hope you can help. I currently have a spreadsheet set up with a macro in; we copy data into tab A, run the macro and it pulls through the info into tab B. We use this to format the information downloaded straight from our bank, however the bank's statements are now downloading in a...

Hello all- I have a VBA question. I have a large data set and want to create a new tab based on each change in salesperson. My data range is A3 to BN3000, with the headers in row 2. Salesperson is in column G, starting at G3. What I want to do is create a new tab at each change in...

I have 50 odd tabs (labels by weekly date range (1st -7th etc) with data in unheaded columns adjacant to a text column on the left hand side, which is the same on each tab. Withing each text column (V) on each tab , the word plums could be written. I want to pull into a table all the...