insert value

  1. R

    VBA to assign "id number" into all files in folder?

    Hi all, I am new to VBA but am learning, and have had some very useful help on here previously, I think what I am looking to do should be possible, but am not sure where to start. I have a batch of 600 files in a folder and need to assign a id/reference number (starting at #1261 ) in to cell...
  2. S

    Using VBA to copy/paste value from one cell to blank table

    Hi, An example of what I am trying to accomplish is as follows: Cell B1 is a drop down list of the variables in the Y axis of the table Cell B2 is a drop down list of the variables in the X axis of the table Cell B3 is the value. Cell B4 contains a VBA button. I am hoping to be able to click...
  3. C

    VBA or macro to loop through rows in master sheet to copy 2nd sheet with value

    Hello, experts! I could really use your help! I consider myself an excel expert (can do pivot tables, formulas, vlookups in my sleep) but have never had to use macros or VBA and desperately have a situation where I need to now. I have a master sheet of data with LOTS of rows where column A...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top