So I am very new to Access and am trying to create a macro that would allow me to enter a number into a window and then go to a specific field and copy and paste the value into an excel sheet. I would need this process to repeat itself until it hits a blank cell.