Hi friends.
How to do:
the user start capture in cell A1="APPLE" go to A2 and capture "ORANGE" and then the user capture in A3="APPLE" here how to check every capture if exist say a message: "Error, captured on A1"
or only can do the task, with a button and with vba code?
thanks
Good Day,
I am hoping there is someone that can help with a formula. The problem is the data is not captured constantly. So i have a name that gets captured in 3 different ways I need to find the value of this person for a specific month. Please if there is formula that I can use would be...
So I have a spreadsheet where I need to capture the rows with values that are less than $1 in a specific column.
In the spreadsheet a number of rows say $0.80 in said column which means it needs to be captured.
The below code runs through every line in the spreadsheet and amongst other things...
I'm trying to figure out how to remove a value from a list using VBA, i have a name range for input, what ever is captured in that cell should automatically be deleted/cleared from worksheet 2 - column G
any ideas on how?
HI, I've got a macro that currently pulls in data from another system and displays each piece of data in a separate column.
Code I have currently working to paste to next column is as follows.
I'd like to display the captured data to the next row instead of the next column.
Dim i As Long
Dim...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.