| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Total is always in column G and the value I need always in column H
Thanks, "Frank Kabel" wrote: Hi is your 'Total' label always in column G? -- Regards Frank Kabel Frankfurt, Germany Jeff wrote: Hello, I need help designing a VBA Macro: I have in cell A1 "Paid" in cell G8 "total" in cell H8 $100.00 What I need is: to cell.find "paid" then to do cell.offset to G8 to select.copy the value in H8. Is this possible ? Regards, |
|
#2
|
|||
|
|||
|
Hi
one way in VBA dim return_value return_value=application.vlookup("Total",range("G: H"),2,0) msgbox return_value -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Total is always in column G and the value I need always in column H Thanks, "Frank Kabel" wrote: Hi is your 'Total' label always in column G? -- Regards Frank Kabel Frankfurt, Germany Jeff wrote: Hello, I need help designing a VBA Macro: I have in cell A1 "Paid" in cell G8 "total" in cell H8 $100.00 What I need is: to cell.find "paid" then to do cell.offset to G8 to select.copy the value in H8. Is this possible ? Regards, |
|
#3
|
|||
|
|||
|
Thank you,
That's What I wanted, but I need first to do a cell.find in column A for"paid" then I can do your macro. Regards, "Frank Kabel" wrote: Hi one way in VBA dim return_value return_value=application.vlookup("Total",range("G: H"),2,0) msgbox return_value -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Total is always in column G and the value I need always in column H Thanks, "Frank Kabel" wrote: Hi is your 'Total' label always in column G? -- Regards Frank Kabel Frankfurt, Germany Jeff wrote: Hello, I need help designing a VBA Macro: I have in cell A1 "Paid" in cell G8 "total" in cell H8 $100.00 What I need is: to cell.find "paid" then to do cell.offset to G8 to select.copy the value in H8. Is this possible ? Regards, |
|
#4
|
|||
|
|||
|
Hi
why do you need this 'find' command first? -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Thank you, That's What I wanted, but I need first to do a cell.find in column A for"paid" then I can do your macro. Regards, "Frank Kabel" wrote: Hi one way in VBA dim return_value return_value=application.vlookup("Total",range("G: H"),2,0) msgbox return_value -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Total is always in column G and the value I need always in column H Thanks, "Frank Kabel" wrote: Hi is your 'Total' label always in column G? -- Regards Frank Kabel Frankfurt, Germany Jeff wrote: Hello, I need help designing a VBA Macro: I have in cell A1 "Paid" in cell G8 "total" in cell H8 $100.00 What I need is: to cell.find "paid" then to do cell.offset to G8 to select.copy the value in H8. Is this possible ? Regards, |
|
#5
|
|||
|
|||
|
Hi,
Because in my worksheet, I have in column A, the following texts: Paid Unpaid Disputed. That's why I need a cell.find first. Thanks, "Frank Kabel" wrote: Hi why do you need this 'find' command first? -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Thank you, That's What I wanted, but I need first to do a cell.find in column A for"paid" then I can do your macro. Regards, "Frank Kabel" wrote: Hi one way in VBA dim return_value return_value=application.vlookup("Total",range("G: H"),2,0) msgbox return_value -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Total is always in column G and the value I need always in column H Thanks, "Frank Kabel" wrote: Hi is your 'Total' label always in column G? -- Regards Frank Kabel Frankfurt, Germany Jeff wrote: Hello, I need help designing a VBA Macro: I have in cell A1 "Paid" in cell G8 "total" in cell H8 $100.00 What I need is: to cell.find "paid" then to do cell.offset to G8 to select.copy the value in H8. Is this possible ? Regards, |
|
#6
|
|||
|
|||
|
Hi
you may provide some more detail about how your complete spreadsheet looks like and what in total you're trying to achieve -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Hi, Because in my worksheet, I have in column A, the following texts: Paid Unpaid Disputed. That's why I need a cell.find first. Thanks, "Frank Kabel" wrote: Hi why do you need this 'find' command first? -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Thank you, That's What I wanted, but I need first to do a cell.find in column A for"paid" then I can do your macro. Regards, "Frank Kabel" wrote: Hi one way in VBA dim return_value return_value=application.vlookup("Total",range("G: H"),2,0) msgbox return_value -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Total is always in column G and the value I need always in column H Thanks, "Frank Kabel" wrote: Hi is your 'Total' label always in column G? -- Regards Frank Kabel Frankfurt, Germany Jeff wrote: Hello, I need help designing a VBA Macro: I have in cell A1 "Paid" in cell G8 "total" in cell H8 $100.00 What I need is: to cell.find "paid" then to do cell.offset to G8 to select.copy the value in H8. Is this possible ? Regards, |
|
#7
|
|||
|
|||
|
Here's an example.
Cell.find "paid" then do activecell.offset to "total" to select "2,672.25" A B G H Paid Gate Safe Catering sealing 52.25 Turn 21 DL Global Selectee PIF 40.00 Turn 0 Aircraft Search 75.00 Turn City of Philadelphia 29.00 Print TOTAL $2,672.25 Thanks, "Frank Kabel" wrote: Hi you may provide some more detail about how your complete spreadsheet looks like and what in total you're trying to achieve -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Hi, Because in my worksheet, I have in column A, the following texts: Paid Unpaid Disputed. That's why I need a cell.find first. Thanks, "Frank Kabel" wrote: Hi why do you need this 'find' command first? -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Thank you, That's What I wanted, but I need first to do a cell.find in column A for"paid" then I can do your macro. Regards, "Frank Kabel" wrote: Hi one way in VBA dim return_value return_value=application.vlookup("Total",range("G: H"),2,0) msgbox return_value -- Regards Frank Kabel Frankfurt, Germany "Jeff" schrieb im Newsbeitrag ... Total is always in column G and the value I need always in column H Thanks, "Frank Kabel" wrote: Hi is your 'Total' label always in column G? -- Regards Frank Kabel Frankfurt, Germany Jeff wrote: Hello, I need help designing a VBA Macro: I have in cell A1 "Paid" in cell G8 "total" in cell H8 $100.00 What I need is: to cell.find "paid" then to do cell.offset to G8 to select.copy the value in H8. Is this possible ? Regards, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
