Devam Ediyor

modifying a macros formula

I was just wondering the cost and how long it might take to change a fairly simple macros formula. What the macros does now is it searches in file from a register to find a specific day's sales file, and the it imports the data into 3 excel sheets. Right now when you hit the button on the sales sheet it asks for the day of the week, then shift, then the date you're looking for. Then it imports the data into the 3 excel sheets - IM,IS,ID The IS, and the ID sheets should import 3 columns of data for each day. The IM sheet should just import the 1 column of data.

Here's what I need done-

When I hit the button-

Enter the date - example (06/30/2006)

When the date is entered it searches for the date in the dat file.

Once it finds the data, dump the appropiate data (IM select sheet) into the columns for the day#30.

So basically you would be taking out the asking for the day of the week, and the shift- and it would only ask for the date.

And Instead of having only 7 days- we would now have 31 days

I Don't need the sales sheet messed with at all, I am going to totally redo it. So basically all I need is to be able to just get the data by entering the date and be available to import the 31 files for the 31 days of a possible month into the 3 sheets, instead of just 7 days.

I'll attatch the excel sheets and the dat file need. I'm sure you can figure it out but in order to get the macros to work you will have to change the path for the dat file to where ever it is located on your computer. There are 2 places to change the path- it's about 1/2 the way down.

Thanks

Beceriler: Visual Basic

Daha fazlasını görün: visual basic cost, formula it, excel sheet formula, sales sheet, modifying, excel formula, basic order taking, register file, searches, macros excel basic, simple data work sheet work macros, visual basic week, change column, excel find select, need formula, formula sheet, days shift, shift days, import data excel sheet, simple figure, excel find date, shift days week, need excel macros, totally, excel sales sheets

İşveren Hakkında:
( 3 değerlendirme ) Champaign, United States

Proje NO: #70950

Seçilen:

xamdam91

Looking forward to working with you

0 gün içinde 100$ USD
(54 Değerlendirme)
6.1

2 freelancer bu iş için ortalamada 75$ teklif veriyor

USA

Hi, i have gone through ur requirement. Here i have placed my [url removed, login to view] let me know when can i proceed.

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0