Search results

Dears, problem which bothers me for a long time. I have an access database with raw data for purchasing. I'd like to simply calculate weekly balance for buys ("Previous week stock/balance" plus "Incoming" minus "Demand") weekly, considering stock from previous week. I think it...

Hi guys, I'd like to import several dozens of text files (MEA - 3D measurements of plastic parts) I know, how to make a code to import several files in once, but just guess, how to read text file with specific structure. Every file has about 10 measurements points of one part - each...

Hi guys, I'm wondering why there are so many Excel examples from profesionals on the web around, but I cannot any for Access. Please, can somebody paste links here with Access examples, so I can learn high level tips & tricks of?

Hi guys, some time ago, I saw a calculation with camera tool picture, floating above sheet. It means during scroling it stood still in a centre of a screen. Stored in a xls file, but without macro in a sheet or module. Do you have idea how that feature was made?

Hi all, is there a way to format number type based on value? My target is to format number like 7856 as 7K 3 234 567 as 3M 234 as 234 all that with just one format setting? I've tried [>10000]0 "K";[>1000000]0 "M";[<1000]0 ' using central Europe regional settings...

Hi all, can anyone provide sample test for MOS Excel Expert certification or a good link? I'm going to get one in march. I've heard that it's "real tasks based" test. It costs not a small amount as well. That's why I wanna be prepared as well as possible. Thanks

Hi guys, could you help me with one formula which can fulfill gray area on a picture below: https://docs.google.com/document/d/1sPgiI1RNXcv7TEnkzD_We-IsVZRHta-FWPqwXAs6kOA/edit?pli=1 I have to consolidate data with layout as picture shows, in orange area. No problem to sumif with...