newbie

  1. B

    New To access

    Ok, im very new to Microsoft Access. My database knowledge comes from trail and error on SQL databases for Forums Like "PHP FUSION" I can pretty much do what ever i want using the sql command box. SO for my very first newbie question out of many to come im sure! Can you use sql santax in Access...
  2. M

    trying to display results by date

    I have a workbook that looks at the data page matches the date on the event page and posts the matching date information to the event page from the data page. (see example below) data list below example. The problem I have is that if the data in the date range is more than 2 events the data...
  3. R

    Help with a Formula that for SUM of count using three categories (two with single "text", and the third has variable text

    Hi, only a newbie to excel here. I've created a booking card for our small B&B. We offer FULL BOARD and B&B, to which I am trying to run a billing section at the bottom. (screen shot link in this thread) Col E7:E18 [Guest Type] Col F7:F18 [Catering Type] Col G7:G18 [Room Type] Col H7:H18 [Date...
  4. J

    Replacing unknown values/text in the same cell as a known word

    Hey you all, I am pretty much a newbie to the whole Excel macro area and I tried my best to Google the answer for my problem but couldn't quite find a satisfying solution to it. So what I am trying to do is to censor all names from an Excel file by replacing the very next word of "herr", and...
  5. K

    Help Centering Image VBA

    Please help. I currently am using the below to insert a picture but it is now going top left. I would like to have this resized to auto fit in the cell with the row height 125. Can someone please help me here? I have researched a few places online and keep getting an error. VBA newbie here...
  6. B

    VBA to generate email

    Hi guys, I need a simple VBA code that will open a new email in outlook and with the TO and CC recipients predefined and the subject line prefilled. Pretty much a newbie to VBA so any help resources for beginners you find useful would be helpful too. Thanks in advance.
  7. Greasle

    fill selected cell with formula

    #Newbie Hi all I tried to write a sub or a function to populate a selected cell with the formular below: =SUBSTITUTE(LEFT(CELL("filename"), FIND("]", CELL("filename")) - 1), "[", "") But i fail. Used examples but no luck. Beware the formula works only with a saved workbook anyone?
  8. M

    Insert same text every nth row

    Hello everyone, I've searched the forums for a suitable answer to this problem but so far with no success. I have a small worksheet with only 1701 rows of data. I need to insert a new row every 5th row. In that new row I need to populate 3 cells (D, E and F) with the same data each time, all...
  9. V

    MACRO keeps falling out

    Hi, I am new to Macros. Have written this simple macro but it keeps falling out at the line in RED? any suggestions? Sub GlassMacro1() ' ' GlassMacro1 Macro ' Add Sheets & put them in order ' ' Sheets("Sheet1").Name = "Raw Data DB Viewer" Sheets("Sheet2").Name = "Working Data DB...
  10. D

    Possible child table for cumulative comments

    Hello, I am currently working on a form which has a "comments" box for people to update. We like the data entry guys to use a specific format of the date and time and their initials and then the comment. Unfortunately they don't always do this properly and miss out some details and have a...
  11. D

    Background Conditional Formatting using a Checkbox

    Firstly I would like to apologise, this is my first attempt at creating a form and table for access so my terminology will be off. We get documents in from customers and I have created a form to "log" and process the documents. One of the things that I am struggling with though is I have a...
  12. D

    Multiple If And Then VBA code

    Hi guys, New to the forum, and also pretty much a newbie when it comes to Formula/VBA for Excel. I'm trying to get some VBA code working (as I know I would be unable to do what I need with a formula, due to the size of it) but I'm not sure where to start. Basically, I'll lay it out logically...
  13. B

    Use the value of a specific cell in the last row

    Hi everyone, I have a pretty basic spreadsheet with 8 columns. Data get added everyday (10 rows per day average) I've done my research on internet but it seems to be rather difficult to find the info I would need. And I am pretty much a newbie. I am trying to create a Macro linked to a button...
  14. M

    Error 1004

    I am trying to create a column "H" that will display the values in column F unless F is empty. In such a case, the value from column E will be entered into column H, however I am new to using vba and am not sure how to fix this macro as it continues to fail on the first line "If...
  15. C

    How do I do this.....?

    Hello guys, Im new wiht the PowerBI tools and trying to keep on... Also, I dont know how to call what I need to do even in spanish (my native language) so I´ll give an example Before that, I'd like to state that this is a real world problem for me, Im working in a large construction project...
  16. D

    VBA if row 1 has text then format those row 1 cells and cells below in certain way

    Hi all, I'm using Excel 2010 and am very new to VBA (halfway through Excel VBA for Dummies 2010). I am trying to create a macro that formats all cells in row 1 that contain text and aligns right all cells with values (text or numbers) below those row 1 cells. My thinking is that it would be...
  17. G

    Combining two similar VBA codes to run on same worksheet

    Hi guys fairly new to VBA coding, having only really started to need the functionality recently. I have a worksheet with several columns where alternating columns are dates of when the previous was updated. I wanted a VBA to update the date when a value is changed starting fromt eh 3rd row...
  18. S

    How to avoid overwriting heading row in Excel after my VBA code runs

    I attempted to write some code to insert a blank row after each change of value in column B. I also change the fill color to grey, add the text "Totals:" to column C and right justify it. I still have one bug. It overwrites the header (column labels) to add the grey bar and totals. Can...
  19. 8

    Formula selection

    I need to able to input city, county, csp territory and protection class territory. Where I input the city and county, and then the corresponding csp, and protection class is pulled from another sheet. I tried vlookup per a YouTube channel but it's not working correctly. Any other ideas?
  20. C

    Another issue with Required Cells in Excel 2010

    I have a workbook with multiple sheets. The end user in my office will only be using one at a time but that sheet needs to be completely filled in. They then save and email the sheet to me. I have read multiple peoples VBA codes to get that to work but everytime I try to save the form it doesn't...

Some videos you may like

This Week's Hot Topics

Top