master

I have 10 sheets that i am moving data from to a master sheet on each sheet there is multiple rows that the data is on. ex sheets 1-10 column b rows 10-30 have data I want moved to master sheet column T rows 25-45 if I write =if(isblank('sheet1'!b10," ",'sheet1'!b10), so if there is data it...

I have managed to create a userform in "Master" workbook which the function is to 'find all' in all worksheet from "Membership" workbook based on value added at text box and its working well, but it is halfway from my target. I need an assistance from expert to find out how to :- auto populate...

Hello there, I have 7 spreadsheets in folder S:\MHS\Review I would like to copy and paste the data from these 7 spreadsheets to a master file (which ideally would be the 8th spreadsheet in the same folder). Very basically... Range("A1").Select Range(Selection...

Need to consolidate about 40 tabs to one master tab with same format columns A-G and add a column for tab name column H.

I need to consolidate about 50 tabs to one master. All tabs have the same format A-G. I would like the master tab to include the name of the tab in a new column "H" so I know which data came from which tab. I tried running a macro I found online and am getting an error "Compile Error: Sub or...

I have a single workbook with (2) sheet tabs as follows - (Plant Schedule Sheet) and (Master Plant Schedule Sheet) (Master Plant Schedule Sheet) https://imgur.com/bR68kqb (Plant Schedule Sheet) https://imgur.com/VUoAXSw What i would like it to do is that whatever number you put in column...

I am trying to match data from one tab to another (or one string to another). The first part comes from an account list which is the client name. I think want to run through a daily report that is just a bunch of strings in the A columns. I can walk thru the code and see it is looking at the...

Hello All, I have been after this project for quite some time and I feel that someone on here with the correct knowledge will be able to assist me. My googlefu is not good enough for VBA projects I guess. I know this will be long winded but please bear with me. I am looking to make a VBA macro...

Hello friends, I want to find out the following. I have 2 sheets namely Master and Vlookup. Master sheet has all the records and Vlookup is the formula sheet. I want to know how I can get information extracted to my Vlookup sheet when there are multiple records with same name but with...

Hi, Can someone please provide me a VBScript code for my below requirement. I have a master tracking document that I use to record project information. My client sends me an updated schedule each week which may (or may not) have additional stores on it and some of the details of the stores may...

Does the parenthesis HIDE in this formula mean the sheet is hidden? I checked the workbook and there are no hidden sheets. Does this mean it's from another workbook? =IFERROR(CONCATENATE("S",VLOOKUP(B2039,'JOB & GRADE MASTER (HIDE)'!$A$1:$C$996,3,FALSE)),"--")

Hi, Can someone please provide me a VBScript code for my below requirement. I have a master tracking document that I use to record project information. My client sends me an updated schedule each week which may (or may not) have additional stores on it and some of the details of the stores may...

Hello all, I am trying to use arrays for the first time and I am flummoxed! Although the array seems to be populating when I write the values to it, any attempt to read those values fail as nothing is returned. Now I KNOW that this is my stupidity and I have checked and rechecked the code that...

Hi – I am very new to VBA and I have been having trouble finding out how to do this. I appreciate anyone who can help me. I have a workbook that contains a sheet named for each person on our sales team, a master sheet, and few various other sheets. The headers for the sales team sheets start...

I have a column of data (Column A) that has the correct information. This information from one cell needs to get corrected on each sheet (there is 1 cell of corrected data for each sheet, and the input location on each sheet is the same). Example: Master value in A2 needs to go to cell B6 on...

I have a master spreadsheet with a "unique sequence number" (like an access unique identifier) for each row. I have split the spreadsheet (keeping the master intact) into multiple tabs in the same spreadsheet based on one criteria (such as city, state). Is there a way to "link" the data for...

Usually I find my answers searching this awesome forum, but this one seems a little bit complicated. I have different Excel files with different number of sheets, what I would like to have is a Macro that does the following: 1) Unmerge any merged cell* 2) Copy all sheets in the workbook 3)...

Hello. I'm looking for a way to duplicate a 'master' Excel table so I can have the exact same table copied multiple times, side-by-side, but with each table sorted and/or filtered slightly differently. The idea is that only the 'master' table be edited and the other tables feed off of it and...

Hi, noobie here. I've set up a workbook with 2 sheets. The 1st sheet is a cert that I fill in for different customers. In the second sheet I've created a customer list database so customer details transfer automatically from sheet1 to sheet2 when I hit the save as button. The problem I'm...