macro - formula

Good Day, I have a challenge for which I have came to a dead end. I would like to achieve to generate 3 lists pulled into an "overview" sheet from data across 52 sheets representing weeks. List 1 would be names of clients called - which would be any non blank cells in the cell references...

Can anyone help with this? The data is numerical data in a column(columnB). The column receives live data updates so it cannot be sorted in numerical order. ColumnA holds time stamps and must remain in original order All the numbers are between 0.1 and 99.9. I need to take sets of numbers (i.e...

Hello experts, I need a quick support from experts in this forum. I am in need to create a simple Excel Tool that should have the following: 1) Questions with Answer Options 2) Set of Questions would be under some categories which will have some weightages 3) Each Answer Options will have...

Hello , I am in urgent need of help. I am quite new to VBA so it might be something obvious but appreciate all comments There is a dynamic range of data in "Mastersheet" in Column "I" that i would like to get their average and return it back to another sheet "Charts" in a specific cell (B1) but...

Hi Guys, Below is a macro for a user form I have in my workbook however I am struggling to add more viewable sheets per user. Dim bOK2Use As Boolean Private Sub btnOK_Click() Dim bError As Boolean Dim sSName As String Dim p As DocumentProperty Dim bSetIt As Boolean...

I have written a VBA that will format a cell in one worksheet based on the value of a cell in another worksheet. It works fine. My question is this: I have 312 cells to format. Each cell on the main worksheet looks to a different cell on the other worksheet. Is there an easier way than to...

Hi all, I'm not sure if I'm even explaining this right. I have two sheets in a workbook. Sheet1 has about 57000 rows and 32 columns of data. I will not show exactly what my sheets look like because this is for work. Examples are purposely vague, but here goes: Col E: Names of people. E.g...

I have a workbook with several tabs where the page numbers all need to be in the lower right footer in lower case Roman Numerals. The code I used is below. The page numbers are only on the 1st page of the document. I need them to number consecutively across all tabs. Right now I am only getting...

Hi guys, These are my Subs: Sub Undosave() Application.ScreenUpdating = False Application.OnTime Now, "Undosave2" ThisWorkbook.Close SaveChanges:=False End Sub Sub Undosave2() Application.Workbooks.Open ("C:\Users\Seth\Documents\Costing Program\Process Costing\Process Costing Updating")...

In a macro, I am trying to enter a formula into a cell and this is the code I am using: Cells(11, 10).Formula = "=LEFT(I11,(FIND(" ",I11,1)-1))" The problem is, excel is trying to enter "=LEFT(I11,(FIND(" as the formula's text instead of the entire formula of =LEFT(I11,(FIND(" ",I11,1)-1))...