main

Hey all, For some reason this is one that I'm really struggling with and I can't seem to get it right. I have a main workbook (Main) which contains a worksheet called "Main Sheet". I also have two other workbooks called Sales1 (worksheet is "Sheet1") and Sales2 (worksheet is "Sheet2"). Both...

I use this macro to take an active roster of people and some data about them, and transfer portions of it to a secondary roster. Unique to the secondary roster is that no one should ever be deleted from the secondary roster. The primary roster is active in the sense that people are constantly...

The macro below generates a roster of people, and then a signature block for the reviewing officer to sign at the bottom of the page. The length of the roster changes, and sometimes the signature block gets split crossed between pages when printed. It's ok if the block is entirely on a page by...

I use this macro to take an active roster of people and some data about them, and transfer portions of it to a secondary roster. Unique to the secondary roster is that no one should ever be deleted from the secondary roster. The primary roster is active in the sense that people are constantly...

Hi there, I'm hoping someone might help. I need to automatically move data from the main worksheet (Detail) to various others, based upon a value in column c. C contains business functions. e.g 1) Finance 2) I.T 3) Marketing ....and so on.... There is a worksheet for each business function -...

Can somebody help with macro for automated paragraph numbering in my document? In column "A" I need to have paragraph numbers. I have three different types of numbering. They are "1", "1.1" and "1.11.1". In column "B" I have text and in column "C" I will insert corresponding text for macro to...

Basic Q here, but having trouble finding best answer. This is simple macro I have on a sheet titled "NXT": Sub CPHC_nxt_CB() Range(Range("CB_wipe_area").value).ClearContents Range("CB_formgrab").Copy Range(Range("CB_paste_area").value).PasteSpecial Paste:=xlPasteFormulas...

Hi All, I have a workbook that we use to track completion of audit tasks The workbook is separated into 4 separate sheets. The 'Main Sheet' lists all of the tasks (there's about 200) Then there are 4 other sheets Sarah, John, Josh & Melissa - these sheets are copied from the main sheet based...

I have never tried this before but ran into a roadblock. I have a macro that runs every time my worksheet is updated. The macro makes about 2 dozen calculations which are output to cells in a worksheet named "Holder" One cell of interest is calculated by this macro and is output to cell "B4"...

Hey all, If someone could help me with this I would really appreciate it. I have a workbook (named Database) which contains 4 worksheets named Main, Leeds, Bradford, York. Ideally I would like to create a drop down list in Main which lists the other worksheets which when selected will...

Hi, I'm struggling to find the answer.. probably because the way I'm wording the search. I have a Main Sub Routine which in turn Calls various smaller Sub Routines. in the 1st Sub I assign a name to the active 'main' workbook eg. Dim workbooknamemain As String workbooknamemain =...

Hi, I have a "main spreadsheet" which vlookups another "spreadsheet data". However there are always new item lookup value in "spreadsheet data" and I need to add it in "main spreadsheet" a few times due to the "main spreadsheet" has to lookup it differently for different weeks period from the...

Hi all: Thanks for taking the time to look at this. Getting a bald spot on my head from scratching. I have a timesheet that is in 2 languages, English and Spanish. When I click on my dropdown language on the main worksheet, the words chane to either English or Spanish. I can't figure out, or...

Have a main sub code and then call another subroutine. All variables have been defined in the main code. However when using the variable in the subroutine I get an error that the variable has not been defined. How can I make sure that variables don't need to be defined in subroutines - but...

Hi I used alt+enter to enter the following in one cell. John Smith 123 Main Street MyCity, 12345 Then I used Clean() to clean break lines. But I ended up with a text look like this John Smith123 Main StreetMyCity, 12345 How can I create a space between "John Smith" and "123 Main Street" and...

I've been asked to create a database for a new funding scheme at my place of work, something I've done before for a simpler funding scheme. One thing I've done in the simpler DB is add a subform that lists all proposals where the applicant name is identical, so we can quickly check whether...

Hi. I am trying to write a formula in G6 of worksheet MAIN that uses the contents of a cell (G4) on worksheet "MAIN" as a reference to a worksheet with the same name (plus one word) as the cell e.g. MAIN,G4 = monkey MAIN,G6 would normally equal = ‘monkey baby’!E30 Unsurprisingly...

Hello everyone, I have an issue. I have made a chart for a game im playing. when i win a match i will type in W and it will automatically show me how much money i made with the use of IF functions. if i put in an L it will do for losing. like this: https://ibb.co/gcBD2U As you can see i have...

Hi All, i'm a newbe so bear with me if this question has been asked and or answered already. Is there a formula that i can use which allows me to select different tabs / sheets using a drop down on my main sheet?. Or a series of formulas that allow me to select a sheet from a dropdown, input...

Hi all, kindly require to provide me support for a VBA code, so that to place in col. “D” the first 4 letters on the left side, from col. “F”. Please see below the original data and the expected result. I would be greatly appreciate any support Thanking you in advance...