-
Hi, I'm fairly new to all this VBA side of ecxel and have gotten to a sticking point. I have a table of information that has several colums of data as shown below. The actual list is a lot longer than this! Document Type Document Number Document Issue Customer Name Copy Type Date of Input Input By...
-
Hi, I need to replace value for E.g."UNCL" . "UNCL" appears in place of some business categories for some products. "UNCL" Should be matched with a list of products in an excel sheet and replaced. Please suggest me on this. Thanks Santtosh.
-
Hello all, I am very new to excel and I need help. Currently, I am writing a macro to populate results into a newly inserted column C (date and time) after I captured info from column A (dates) and column B (time) for a list of data that could easily go beyond thousands row of records. So far, I managed...
-
Hope someone can help with this...it is beyond bizzare. I watched this several times now. n = the number of columns of data. When n=4, as t cycles through, section A is accessing section B to pull the data out of the spreadsheet. When t = 3....A1(3) returns as zero. Not ""...zero. The value...
-
My program accesses a series of *.csv files and transfers the data of interest into an excel sheet. The data in column 4 of the csv file is used as the search reference. The data I am pulling starts in column 12. I have had some files with as many as 7 additional columns of data. I have two sections...
-
Hello All, I have been trying to locate VBA code that will allow me to complete this scenario: A worksheet named "Data" has data in this range (A1:G1). Once the button (form control) is pressed the workbook is saved and then this needs to occur: The data on the worksheet named "Data"...
-
Hi ... I'm having trouble with the bolded line below ... wondering if anyone can help me with the code needed to make the tab always appear at the end, instead of after a specific tab. Tks, Mike Sub RollForward() ' ' RollForward Macro ' ' Keyboard Shortcut: Ctrl+Shift+Y ' ActiveSheet...
-
Need Assistance ... If someone could point me to a book/article to read up on the following ... I have an Excel spreadsheet that works fine on PC and on MAC's running Excel in a PC emulation/window ... The macro's in the spreadsheet detect when the ALT, SHIFT, CONTROL keys are depressed ... and...
-
Please help! I have spent way too much time trying to figure this out, so I'm really hoping someone can help. I have recorded vb that changes a page item in a pivot table when selecting from a combo box - similar to this video. http://www.datapigtechnologies.com/f...s/pivot10.html . The recorded...
-
Is there anyway I can automate my sheet so it will print in PDF format and either save to my Shareware site or print to a drive and email to my Shareware site? I have tried recording a macro to see if I could find some code but no luck and I cannot find anything in the literature I have.