I am writing to seek some help in creating a outlook macro, which is able
extract all xls attachment files into one excel workbook (save each
attachment in individual worksheet) from specific outlook folder called
‘data’, which is sub-folder under the Inbox folder.
I manage to find the fol
Thank you very much for your answer & great working solution, to my thread.
I really appreciate you adding in additional requirement, at a short
notice.
Thanks a million for your help. :)
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
Apology for not making my question clearer.
in my recent post, the new requirement is defined as a new additional to
requirement.
Thank you for your reply and any further help.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join officia
Dear Vabz,
Thank you for the reply and providing a great solution.
I would like to request a small update into the existing code, by adding a
new condition, if its not too much trouble:
else if (F) = (int value)+N or E
copy. cell(F)&(G) = paste.cell(H)&(I) *
(*) - i.e. 23E, 100N, 78N
Thank
Dear all,
I am writing to seek help, in creating a macro, which can find specific
values from column F and if those values (conditions) equal true in column
F, then copy column F and G and paste it into column H & I.
Here are the conditions:
if (F) int values >= 125(whole number)
copy. cell(F
Could someone please provide some assistance, if possible.
Thank you for your time and help.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1)
Dear Pramod,
Thank you for your reply back.
I am writing to request, if it is possible to update the code, so it also
extracts the name's prices and type, if its not too much trouble.
Please see the updated new attachment for further details.
Thank you so much for all your help and time into
Dear Pramod,
Than you very much for your solution. I really appreciate your time and
help into this. I have one small question, which is I would like to change
the range of where the data is pasted in sheet2, however I am unable to
access the code as it s password protected. is it possible
>
> Thank you for your solution and help. I am ideally looking for a macro,
> which can extract the names and prices, hence I would like to be able, to
> add more features to the code and it would update quickly when the input
> data changes in the sheet1.
>
the desired output is -- extract
>
> Dear Paul,
>
Apology for the late response. Thank you so much for hardwork and help.
The macro works great, exactly what I was looking for. Thank you very
much, I really appreciate your time and help.
Sorry, once again for the late response to your code.
Thank you!
--
Are you =EXP(
>
> Hi Paul,
>
Thank you so much for your time and effort into problem. The code is very
well structured, but I am sorry to inform, that code highlighted every row
in sheet1, as the correct output would be highlighting every row in sheet1
besides row 6, as its not the same as sheet2 row6.
I have a large amount of data in two worksheet. I would like the macro, to
search the two sheets and look for duplicate rows of data by comparing
columns A, B, C, D, F, H, I between the two worksheets. Show the results by
highlighting the duplicate rows in both sheets.
I have attached a sample
Hello,
I am trying to implement the following calculation:
column F (input) 100-05 3/4 --> Column G (output) 100.085
100+(05+3/4)/32 --> logic
the new logic is represented through case "/" in the code below, *which is
currently not outputting any result.*
Sub dashes()
Dim Rng As Range, Dn A
Could anyone, please any assistant with the above issue, thank you.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
Dear all,
I am writing to request help in updating my current macro code, so it
output's name count based on unique values from coulmn A, B and C, as
currently it is based on only column B.
current output:
can be shown on the example workbook in sheet 4
desired output:
RBS = 5
CA = 1
SG = 1
15 matches
Mail list logo
