ideally

Hi all, I have created a macro which reads column B and then creates separate sheets based on the values-text found on that Column. I obviously get an error while new sheets are created. The 1st one is when text is over 31 characters. This is resolved. The 2nd one is when i have the 7 sin...

Hi all, I have some coding that I have developed over time - but I'm stuck at one particular point. In 'column B' I have a list of dates, they are all in the same format (UK). What I want is some coding that deletes any row that has a date from the current year (I'll be using this code going...

Hi everyone! I’m trying to put together an expense tracker in Excel. The intention is to take an extract from online banking on a monthly basis which would give me a list of all my expenses. The extract includes the date the expense was incurred, a description of the expense, the amount...

Hi, I am trying to find a way of listing data from Column DW if column ED is Greater than 0 and column EK is "ABC" I would ideally need the data to be under each other rather than on separate rows Hope this makes sense Many thanks

OK here is what I am trying to do I have a workbook (lets call it A) which has a fixed name and stores the VBA codes. The macro in A creates a workbook (B) which is saved under a name which varies. Another macro in A does some processing on B. Ideally, I need a VBA subroutine to switch...

Hello, I need help with a spreadsheet form, at my workplace I have Certificate to be filled in, so far manually:(, using other spreadsheet with information(Data Sheet). Both are forms not tables so there are lots of merged cells in them and have different layout, and I would like to make...

Hi there, I need a VBA code to check for the date in the AI4:AI9999 and to move the entire row of oldest date right to the top, ideally setting it all up in the order from the Oldest to the Newest date. All my data is in C4 to AQ9999, Any ideas? Thanks

Hi, Is it possible to modify the following AND formula to suit a range rather than a static value of 0.5 Ideally within the range of 0.5 and 0.7 The formula I have is =AND($L7<>"",$L7>0.5) Many Thanks

I have a spreadsheet that has numerous entries by individual. The sheet logs all accidents that have taken place on site and I want to be able to provide a summary by individual. I have tried pivot tables but that just shows how many times each individual has an entry. Ideally I would like to...

Hi there, I am having trouble getting a formula to work. I have two spreadsheets within one workbook. The first one has a list of Postcodes. The second one has Post Codes and names. I need to pull the names through from the second spreadsheet over to the first one. So ideally it will...

Hello, Is there any way that I can use a formula to convert a number to a multiple of 2, 5 or 9? I need it to round to the closest ideally. For example: 252.9 = 252 255.8 = 255 260 = 259 Many thanks in advance

Morning All, I have the function below that i use to copy down a cell to end of the column. LR = Cells.Find(what:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row Range("A3").AutoFill Destination:=Range("A3:A" & LR) However i want to make this dynmanic as the Range may...

Hi all, Someone may have done this before or had some ideas on how to do it so thought I'd check before I dedicated time to it... I have data in a tree and needed to convert it to a '.' separated hierarchy as below. <colgroup><col width="70" span="4" style="width:53pt"> </colgroup><tbody>...

Hey Team, Is it possible to put in the month (say October) and then have it autofill certain boxes with the dates for that month? I'll attach a work book. So ideally you'll enter the month in A1 and it will change the boxes marked d/mm/yy with the dates descending. Thanks Clyde

Book2 - Google Sheets Hello, above is a sample of my spreadsheet. Is there a more eloquent formula to the Nested IF ISNUMBER formula I currently have in Column C? I need to extract the date from column A. In future the 'dates list' might be modified to words/phrases/letters, hence why I have...