Hi All
I've been using below code without any problems on 32bit, however doesn't work in 64bit.
' Export UserForm as PDF (image)
Dim pdfName As String
Dim newWS As Worksheet
keybd_event VK_LMENU, 0, KEYEVENTF_EXTENDEDKEY, 0
keybd_event VK_SNAPSHOT, 0...
Hi There
Need some help, please.
I have a file with 2 workbook (sheet1 and sheet2, on sheet1 have various columns, where on sheet2 only have 4 columns, however both worksheets have hundreds of rows.
What I'm looking after is that:
On sheet1 A2:A4 & F2:F4 (as a index)
On sheet 2 look and match...
Hi vletm
Some of the rows doesn't copy properly, as you have mentioned probably due to the spaces on the source file.
Could you please let me know what [#All] after table1 does?
Anyway, thank you for your help.
Regards
R
Hi There
I'm trying to use this formula:
VLOOKUP(B3,[Source.xlsx]Sheet1!$A$3:$H$10,{6,7,8},FALSE) ; without success, could some please help me on this one?
Brief:
Have two files, one named "Formula" (where I have the Vlookup formula) and other named "source".
The formula file "Column B" has...
Hi All
On the file attached shows on column H the values from column F sorted by the largest to the smallest value. However I would like to rate the highest value on column J to 1, the next highest to 2, next to 3 and so on.
Could someone please help me with formula?
Thanks.
Regards
Americo
Hi There
Have a column with 7000 + records (text), would like to extract to another column, a list with text strings ignoring duplicates and blanks cells.
I'm using on cell C2 a formula but doesn't return what I need.
File attached.
Thanks in advance.
Regards
R
Hi All
I am wondering if someone could help me please.
Need to calculate date and time difference between three columns.
The problem I'm facing is that, one of the dates and time are in a separate columns (F&G):
Column F=date
Column G=time (of F)
Column K = date & time together (separate...
Hi
Tried that, but the code doesn't work.
On sheet2 cell N7, set a date, so either when before close or save should move/paste the row to sheet3.
Could you please help?
Thanks again
R
P45cal
The reason I need it, part of the another piece of code is (archive) data move the entire row and past it in a another worksheet and after run the code the cell "o" loose the formula, probably the copycells code is not correct (file attached).
On sheet2 cell o7 the conditional formula is...
Hi There
I tried to use without success below code to force the formula to set & refreshed when workbook opens
Would like to set a range Sheet2 O6:O10000
Conditional formula:
=IF(L6="","",IF(L6-TODAY(),"Action Needed",IF(L6<TODAY(),"Overdue",IF(L6>TODAY(),""))))
ActiveCell.FormulaR1C1 = _...
Hi All
I'm wondering if someone could help me with a couple things, please?
1 - when change a date on sheet2 column L, should copy entire row to Sheet3 starting on cell C6 (code on sheet2), so records every time the date is changed.
2 - Code on Module1 Sub copy cells, wondering if possible to...
Hui,Narayan
Thank you for your prompt reply.
@Narayan
I need the opposite, if possible.
This week - Australia/Brazil how many cells on deadline column
in 1 week time - Australia/Brazil how many cells on deadline column
in 2 weeks time- Australia/Brazil how many cells on deadline column
Tried...
Hi there
I'm looking for a formula (samples on sheet1 C6 to C10), to sum how many cells on sheet2 column L have a date (this week, 1week, 2weeks,etc) based on column E (countries).
The formulas on file attached works fine only with one criteria.
Any help will be appreciated.
Thanks in advance...
Sorry, forgot to say that, sheet3 works as a archive of sheet2, when row(s) on sheet2 are set to complete.
When set to complete the entire row is moved to sheet3.
I need to look for the last number on both sheets 2&3 C6:C2000.
Thanks for your help.
R