Recent content by nina1

Thanks a lot to everybody, offset function worked perfect

The "Part" section doesn't have equal number of rows, sometimes it might be more then 10 rows in one section. The last 'Part" in column A can be used to terminate the process even if I have to do a couple of rows manualy it is better then doing 17000 rows. Thanks a lot for your help!

The excell sheet contains 17000 rows with data and there are multiple part numbers that are displayed in the order I displayed, the last set of part will look like this Part 03999-01 empty cell empty cell empty cell empty cell empty cell

Column A "Part" should stop the copy process. Right now it looks like this: Part 3222-01 Empty Empty Empty Part 3444-02 Empty Empty Empty Part 3555-03 Empty Empty Empty and so on and I need it like this Part 3222-01...

I am new to VBA and I need help for a simple macro that will look at the value in A column "Part" and copy the value of B column down till it gets to the "Part " again and loop to the end. It should looks like something like this: Part 3222-01 3222-01 3222-01...

I have a table in MS Access that looks like this: Parent PName Child CName Clevel SupID Supplier ChildQty 11111 base 111-05 pppp A1 00555 uuuuuu 1 11111 base 111-04 llll B1 00553 mmmmmm 1 11111 base 111-07 hhhh c1 00333 dddddd 2 and so on. I have abot 150...

Hello! I have two tables joined by PartSupID, the first table(Part) contains all info about the product Part#,supplierID,Name, currency etc and PartSupID (combination of Part# and supplier ID) as a primary key. The second table(Price) contains the price information like POPrice, contract#...

I have a combo box as a month selection. Combination of the combo box selection and a fixed word like "Alum" would be my field in a table to update. For example my current selection is "JUl" and I would update the field "AlumJul" in a table.Something like this. Update Cost set...

I use Crystal reports version 10 and Betriave database. I am exporting invoices with multiple line items and my problem is with the description field. The data look like this: Invoice# item# Description Qty 3888 Order#4555 0 3888 BOL#000055 0 3888 PacKL:3888...

Hi, My questions might look stupid but I am stack on this event. I just want this event to be fired when the user click save button and dispyay the message box to check the data before saving it. My module look like this: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As...

Yes and for Alt-P is the same change, but the problem is that the button needs to hava a focus in order that this shortcuts works.

I have three buttons on the form "Save", "Exit" and "Print", when the user save the record it might go to the entry box again (combobox on the form) or might just close the form or print entered record. My problem is how to recognize user's input. I have shortcuts like Alt + S-Save, Alt +...

Hi, I am new in VBA and I need help to write this small macro. I have an excel file that look like this: Parent# child # 110 320 110 450 110 220 150 440 150 320 150 125 150 130 and so on. I need to write a macro that will copy child#...

I set up six exports macros with the specs to export six queries into six text files. Now I would like to create a macro that will copy each six files into one file. Can somebody help me with a sample. Thanks very much!

Sorry I didn't explain the problem completely the first time so now I will try to do it better. I started the sales database, I have a customer_parts table, local_part table and bill_to table every month end I am going to get a prodact sales report in Excel with the customers part#, local part#...