[Solved] Using macro to find information

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
hank_shakti
Posts: 5
Joined: Mon Jul 18, 2016 3:43 am

[Solved] Using macro to find information

Post by hank_shakti »

Hi everyone,

I have an online business and I can down load sales information file every day. But, this file missing three important information. So, I thought that I can create macro to find those information from the inventory file. So, first I copy the inventory file in sheet 1 and uploaded sales file in sheet 2. I copied the sku from the sheet 2 and open find window in sheet 1 and paste the sku on it and find it. Then I copied those three information and move to sheet 2 and paste it to the appropriate position. It worked well, but Idea was to change the sales file everyday and do the same process everyday. But my macro is using the same sales file of which the original macro process was saved, even though I uploaded a new sales file to the sheet 2. Is there anyway, macro handle the same process on the new data set?
Last edited by MrProgrammer on Wed Oct 28, 2020 7:23 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
open office 4.1.2, Window 10
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Using macro to find information.

Post by MrProgrammer »

Hi, and welcome to the forum. I don't think you need an evil macro. Copy the matching data from sheet 1 to sheet 2 using the VLOOKUP formula.

[Tutorial] VLOOKUP questions and answers

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
hank_shakti
Posts: 5
Joined: Mon Jul 18, 2016 3:43 am

Re: Using macro to find information.

Post by hank_shakti »

Thank you for your welcoming message and the potential answer. I am going to test it out. Thank you again!
open office 4.1.2, Window 10
hank_shakti
Posts: 5
Joined: Mon Jul 18, 2016 3:43 am

Re: Using macro to find information.

Post by hank_shakti »

I have tried several times. This is the formula: =VLOOKUP(Sold.E2;$B$2:$H$77728;5;0). It correctly identify the sku and the information that I am looking for. But, it write the output on the sheet 1. Do I have any control where output should go? I want the output written on the sheet2, the same row with the sku that I am looking for.

Regards,

hank
open office 4.1.2, Window 10
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Using macro to find information.

Post by MrProgrammer »

hank_shakti wrote:Do I have any control where output should go?
You put the formula in the cell where you want the result to be displayed. So if the output should be displayed on sheet 2, the formula must go on sheet 2. Read section 8. Using formulas and cell references in Ten concepts that every Calc user should know, specifically the fourth sentence in the section. Based on that question, you should probably read the entire tutorial. I think you will learn a lot from it.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
hank_shakti
Posts: 5
Joined: Mon Jul 18, 2016 3:43 am

Re: Using macro to find information.

Post by hank_shakti »

Thank you! I will do my home work and let you know how it goes. Best regards, hank
open office 4.1.2, Window 10
hank_shakti
Posts: 5
Joined: Mon Jul 18, 2016 3:43 am

Re: Using macro to find information.

Post by hank_shakti »

Hi MrProgrammer,

I struggled for all the last weekend saving numerous frustrating macro trials, you solved it in five minutes after I read your last instruction. Thank you so much for your advice, you saved us about 1 hr day for sorting printed out packing slips by sku for picking.

Special regards,

hank
open office 4.1.2, Window 10
Post Reply